NTSB investigations: Cessna A150M, CA
9 cases on aircraft the registry lists as Cessna A150M. 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
| 1981 | 2 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 2005 | 1 |
| 2011 | 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\" = 'CA' 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 ('2071831'))
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" = 'CA' 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 ('2071831'))
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 WPR11CA148Accident · No injuriesData collectionFinal reportCessna A150M · Grass Valley, CAThe aircraft's encounter with deep snow during the landing roll out. Contributing to the accident was the airport manager's failure to update the AWOS recording to reflect the closure of the runway due to snow.NTSB LAX05CA257Accident · Minor injuriesData collectionFinal reportCessna A150M · Trinity Center, CAthe pilot's failure to select an adequate altitude, which would assure clearance from the mountainous terrain while flying into a box canyon in high density altitude conditions.NTSB LAX93LA334Accident · No injuriesLimited investigationFinal reportCessna A150M · Sacramento, CAThe dual student pilot's failure to maintain directional control, improper use of the flight controls, and failure to relinquish the flight controls to the CFI. The soft dirt was a factor in this accident.NTSB LAX90LA096Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Inyokern, CAThe pilot's failure to refuel which led to fuel exhaustion.NTSB LAX87LA223Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oxnard, CAThe pilot departed Oxnard arpt on a VFR flt to whitemant arpt, los angeles, CA. Grnd witness obsvd the airplane enter clouds and fog after crossing the western edge of the arpt boundary. The airplane was then obsvd in a descending left turn south of the arpt.…NTSB LAX87LA043Accident · No injuriesLimited investigationFinal reportCessna A150M · Corona, CADuring a local flight, the pilot was practicing a simulated engine out procedure toward an open field on rolling terrain. He stated that he misjudged the rising terrain and got too low and slow to initiate a go-around. Subsequently, he was forced to land.…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…NTSB LAX82FUA07Accident · No injuriesClosedCessna 150 · Laguna Beach, CANTSB LAX81FUQ17Accident · No injuriesClosedCessna 150M · Van Nuys, CA