NTSB investigations: Cessna A150M
5 cases on aircraft the registry lists as Cessna A150M, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1987 | 2 |
| 1994 | 1 |
| 1996 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071831')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071831')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 FTW96FA089Accident · 1 fatalField investigationFinal reportCessna A150M · Vinita, OKFailure of the pilot to recover from a spin. Factors relating to the accident were: the pilot's ostentatious display and the lack of altitude (terrain clearance) for recovery from the aerobatic maneuver and subsequent spin.NTSB MIA94FA148Accident · 2 fatalField investigationFinal reportCessna A150M · Indiantown, FLThe pilot's impairment of judgment and performance due to alcohol and drugs, which led to his improper planning/decision, and his failure to maintain adequate airspeed during a maneuver.NTSB SEA87LA198Accident · No injuriesLimited investigationFinal reportCessna 150A · Tacoma, WAWhile lndg, the plt decided to go around. He stated the acft floated as he applied pwr & the pwr increased to about 2400 RPM. He raised the nose slightly & retracted the electrically operated flaps from 35 to zero deg. He said he established a climb to about…NTSB MIA87LA123Accident · No injuriesLimited investigationFinal reportCessna A150M · Jackson, MSThe plt stated that he failed to remove the control column gust lock prior to take off. Immediately after rotation, the acft began to porpoise, descended uncontrolled, & landed hard collapsing the landing gear. He further stated that this accident could have…NTSB FTW82DA142Accident · Minor injuriesFinal reportCessna A150M · Raymondville, TXThe pilot stated that on takeoff the aircraft hit a bump and became airborne. The aircraft settled back on the runway and the nose gear collapsed. Witnesses stated that the aircraft became airborne then stalled. The wind was reported as 15 knots with gusts to…