NTSB investigations: Cessna 150M, ID
9 cases on aircraft the registry lists as Cessna 150M. 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
| 1979 | 1 |
|---|---|
| 1981 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2005 | 1 |
| 2018 | 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\" = 'ID' 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 ('2071830'))
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" = 'ID' 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 ('2071830'))
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 GAA18CA095Accident · No injuriesData collectionFinal reportCessna 150 · Nampa, IDThe pilot’s geographic disoriention during a night flight, which resulted in an off-airport landing.NTSB SEA05LA098Accident · 1 fatalLimited investigationFinal reportCessna 150M · Elk River, IDThe pilot's inability to control the airplane during initial climb due to the restricted movement of the control yoke and rudder control by the passenger, which resulted in a loss of control and impact with trees.NTSB SEA99LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Glenns Ferry, IDThe pilot's failure to maintain directional control during the attempted takeoff. A related factor was the pilot's lack of recent experience.NTSB SEA99LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · Buhl, IDAn inadequate recovery from a bounced landing. Gusting wind conditions were a factor.NTSB SEA97LA183Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, IDThe pilot's failure to attain rotation speed. The pilot's failure to maintain aircraft control and rough runway conditions were factors.NTSB SEA95FA052Accident · 2 fatalField investigationFinal reportCessna 150M · Burley, IDThe failure of the dual student to maintain airspeed while maneuvering, and the flight instructor's inadequate supervision.NTSB DEN89LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Gooding, IDImproper inflight decision of the pilot to continue the flight without refueling which resulted in fuel exhaustion.NTSB SEA81DYA22Accident · Serious injuriesClosedCessna 150M · Driggs, IDNTSB SEA79DYA28Accident · No injuriesClosedCessna 150 · Prairie, ID