NTSB investigations: Cessna A150M
5 cases on aircraft the registry lists as Cessna A150M, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1984 | 1 |
| 1990 | 2 |
| 2000 | 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\" = 353))
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" = 353))
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 MIA00LA162Accident · No injuriesLimited investigationFinal reportCessna A150M · Gainesville, GAThe pilot's failure to use proper soft field landing technique while attempting a forced landing to an open field following a loss of engine power which resulted in a hard landing. Factors in the accident were weather conditions conducive to formation of…NTSB CHI90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Moorhead, MNThe pilot's poor in-flight planning and fuel system monitoring, and his failure to maintain directional control during the subsequent forced landing.NTSB LAX90LA096Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Inyokern, CAThe pilot's failure to refuel which led to fuel exhaustion.NTSB CHI84LA235Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Wadsworth, OHThe acft touched down 200 ft short of the rwy after the engine lost power on the final approach. During landing the acftcollided with a creek embankment. The plt stated that while on final approach he applied carburetor heat and throttled back. When he…NTSB CHI83LA052Accident · No injuriesLimited investigationFinal reportCessna A150 · Fostoria, OHThe student pilot was practicing ground reference maneuvers when he experienced a power failure. A forced landing was made in an open plowed field. The aircraft nosed over. The aircraft had been flying about 1 hour and was out of fuel. It as estimated that…