NTSB investigations: Cessna A150K
10 cases on aircraft the registry lists as Cessna A150K, 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
| 1983 | 3 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2007 | 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 ('2071824')
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 ('2071824')
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 DFW08FA036Accident · 1 fatalField investigationFinal reportCessna A150K · Mesquite, TXThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb. Factors contributing to the accident are the instructor's decision to takeoff with excessive flaps, the improper maintenance replacement of the flap…NTSB ATL98FA025Accident · 2 fatalField investigationFinal reportCessna A150K · Jacksonville, FLthe pilot's failure to maintain adequate flying speed following a banner pick up, which resulted in a stall and an uncontrolled collision with the ground. A related factor was: the pilot allowed the maximum certificated gross weight of the airplane to be…NTSB FTW94FA138Accident · 2 fatalField investigationFinal reportCessna A150K · Mccrory, ARWas the inadvertent stall and spin. Factors were the pilot's performance of aerobatics at an inadequate altitude.NTSB ANC90FA146Accident · 2 fatalField investigationFinal reportCessna A150 · Kenai, AKPilot-in-command's failure to maintain control of the airplane.NTSB CHI87FA129Accident · 2 fatalField investigationFinal reportCessna A150K · Scotts, MIThe airplane had been circling a residence at tree top level when a witness saw the nose drop and the acft descend steeply toward the terrain. The airplane struck a power line before ground impact.NTSB DEN86FA170Accident · 1 fatalField investigationFinal reportCessna A150K · Silver City, NMThe student plt took a private plt for a sight seeing ride. The acft was over gross weight and the density alt was calculated to be 9,292 feet. On an approach to landing the student plt elected to go around. The surviving plt said that in a steep bank the…NTSB LAX84LA295Accident · No injuriesLimited investigationFinal reportCessna A150K · Trona, CAThe acft settled back to the rwy and veered of the left side during takeoff. The plt stated that he attempt a short field takeoff and the acft would not accelerate to more than 60 mph. It settled onto the dirt off the left side of the rwy and groundlooped to…NTSB LAX83LA355Accident · 1 fatalLimited investigationFinal reportCessna A150K · Stonyford, CAThe acft collided with the ground while negotiating a low level aerobatic maneuver. The acft had departed a private ranch airstrip and according to a witness the acft was 'rolled'. After a few circles of the strip. The witness was surprised because the plt…NTSB LAX83LA307Accident · Serious injuriesLimited investigationFinal reportCessna A150K · San Diego, CAWitnesses observed the acft circling over the housing development at low altitude. The acft banked steeply, pitched up & the nose fell through the horizon. The student plt flying the acft resided four houses away from where the acft crashed.NTSB LAX83LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Tucson, AZThe acft became misaligned with the runway during landing and landed in a crab which collapsed the nose gear and the left main gear. The pilot stated that he got caught in a dust-devil which blew him sideways. According to the operator who witnessed the…