NTSB investigations: Cessna 150J, IA
16 cases on aircraft the registry lists as Cessna 150J. 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
| 1969 | 2 |
|---|---|
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2023 | 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\" = 'IA' 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 ('2071820'))
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" = 'IA' 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 ('2071820'))
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 CEN23LA163Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Buffalo, IAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning. Contributing to the accident were the unreliable fuel quantity gauges and the improperly adjusted mixture control, which increased the fuel consumption…NTSB CHI04CA286Accident · No injuriesData collectionFinal reportCessna C-150J · Oxford, IAThe student pilot's failure to attain a proper glidepath which resulted in exceeding the proper touchdown point. An additional cause was his failure to abort the landing. The embankment was a factor.NTSB CHI03LA049Accident · No injuriesLimited investigationFinal reportCessna 150J · Garner, IAThe students pilots improper in-flight fuel planning resulting in exhaustion of the fuel supply, and the collapse of the nose gear during the forced landing. Factors were unsuitable landing are encountered by the pilot, the plowed field and the fuel…NTSB CHI97LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodbine, IAThe pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.NTSB MKC85LA067Accident · No injuriesLimited investigationFinal reportCessna 150 · Keokuk, IAWhile taxiing for t/o on a sod rwy, gusting winds flipped the C-150 over after it became bogged down in the soft terrain. The plt was aware of the gusting wind conditions but was not expecting to get the a/c stuck, even though the pilot was aware it had…NTSB MKC83LA012Accident · No injuriesLimited investigationFinal reportCessna 150 · Nichols, IAThe pilot taxiied into a soft spot on his private airstrip which raised the wing. The wind got under the wing and flipped the aircraft over.NTSB MKC81DCD37Accident · No injuriesClosedCessna 150J · Eagle Grove, IANTSB MKC76DCD44Accident · No injuriesClosedCessna 150J · Muscatine, IANTSB MKC76FCD03Accident · No injuriesClosedCessna 150 · Lowden, IANTSB MKC73DCD46Accident · No injuriesClosedCessna 150 · Farson, IANTSB MKC73DCD37Accident · No injuriesClosedCessna 150 · Anita, IANTSB MKC72DCD02Accident · No injuriesClosedCessna 150J · Des Moines, IANTSB MKC71DCD06Accident · Minor injuriesClosedCessna 150J · Muscatine, IANTSB MKC70DCD11Accident · No injuriesClosedCessna 150J · Riverside, IANTSB MKC70D0242Accident · No injuriesClosedCessna 150J · Waterloo, IANTSB MKC69D0423Accident · Serious injuriesClosedCessna 150 · Irwin, IA