NTSB investigations: Cessna A150M
4 cases on aircraft the registry lists as Cessna A150M, where the first occurrence was “Loss of engine power”. 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1995 | 1 |
| 1997 | 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\" = 350))
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" = 350))
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 SEA97LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Freeland, WAFuel exhaustion due to the flight instructor's failure to insure there was proper fuel in the aircraft and the flight instructor's misjudgment of his altitude and airspeed while executing a power-off forced landing in a large open field. Factors include: a…NTSB FTW96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Santa Fe, NMLoss of engine power for undetermined reasons. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB SEA88LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Port Angeles, WADuring cruise the pilot noticed a gradual loss of RPM. Carburetor heat was applied but the pilot stated that he noted no improvement in the engine power. The power loss continued to deteriorate so a landing was made onto a rough field where the nose gear…NTSB LAX84LA126Accident · No injuriesLimited investigationFinal reportCessna A150M · Castaic, CAAfter the plt landed on an abandoned road, the aircraft went off the right side, near the end of the roadway, then went over an embankment & nosed over. He did not submit an accident report (NTSB form 6120.1). However, he told sheriff's deputies that he made…