NTSB investigations: Cessna 150E, MI
18 cases on aircraft the registry lists as Cessna 150E. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 3 |
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1998 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071812'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071812'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI98LA333Accident · No injuriesLimited investigationFinal reportCessna 150E · Cadillac, MIthe pilot's inadequate evaluation of the wind condition which resulted in landing on the wrong runway. A factor associated with the accident was the tailwind.NTSB CHI90DEM01Accident · 1 fatalFinal reportCessna 150E · Grayling, MIA loss of aircraft control for undetermined reasons.NTSB CHI87LA126Accident · No injuriesLimited investigationFinal reportCessna 150E · St. Johns, MIThe plt reported that a gust of wind caught the acft during landing and he immediately added full power in a go-around attempt. The plt stated that the acft then stalled in trees and a fence row.NTSB CHI86FEM11Accident · Serious injuriesFinal reportCessna 150E · Muskegon, MIThe plt rprtd that drg takeoff, the acft lifted off at about the midpoint of the rwy & climbed to just above treetop level. He turned the acft slightly into the wind, then noted that it seem to lose the ability to climb further. The stall warning horn sounded…NTSB CHI74DEC45Accident · No injuriesClosedCessna 150E · Lincoln, MINTSB CHI73FEM06Accident · No injuriesClosedCessna 150 · Marquette, MINTSB CHI72FEM75Accident · Minor injuriesClosedCessna 150E · Crystal, MINTSB CHI71FEC46Accident · No injuriesClosedCessna 150E · Memphis, MINTSB CHI71FBJ03Accident · No injuriesClosedCessna 150 · Houghton, MINTSB CHI70DBJ23Accident · No injuriesClosedCessna 150E · Houghton, MINTSB CHI70F0328Accident · No injuriesClosedCessna 150 · Pontiac, MINTSB CHI69A0072Accident · No injuriesClosedCessna 150 · Salem, MINTSB CHI68F0326Accident · No injuriesClosedCessna 150 · Pontiac, MINTSB CHI68F0288Accident · No injuriesClosedCessna 150E · Salem, MINTSB CHI67F0676Accident · No injuriesClosedCessna 150 · Crump, MINTSB CHI66F0757Accident · No injuriesClosedCessna 150 · Lansing, MINTSB CHI66F0454Accident · No injuriesClosedCessna 150 · Kalamazoo, MINTSB CHI65D0079Accident · No injuriesClosedCessna 150 · Lansing, MI