NTSB investigations: Cessna A150L
12 cases on aircraft the registry lists as Cessna A150L, 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 |
|---|---|
| 1983 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1999 | 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 ('2071828')
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 ('2071828')
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 CHI99LA349Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Detroit, MIthe pilot's failure to maintain control of the airplane which resulted in the inadvertent spin. A factor was the pilot snagged the banner pole.NTSB MIA97LA081Accident · Serious injuriesLimited investigationFinal reportCessna A150L · St. Mary'S, GAthe pilot's failure to maintain airspeed which resulted in an inadvertent stall the at too low an altitude to allow recovery. A factor in this accident was the pilot's attention was diverted.NTSB ATL97FA034Accident · 2 fatalField investigationFinal reportCessna A150L · Trinity, ALfailure of the pilot to maintain flying airspeed, while maneuvering at low altitude, which resulted in a stall and subsequent collision with a tree, utility line, and the ground.NTSB CHI96LA147Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Blaine, MNfailure of the pilot to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall/spin.NTSB BFO93FA169Accident · 2 fatalField investigationFinal reportCessna A150 · Greenbelt, MD1) The pilot's poor judgement in buzzing a residential area, 2) his failure to maintain an airspeed above the aerodynamic stalling speed, which led to a stall/spin, and 3) the inability of the pilot to take remedial action and recover from the stall/spin due…NTSB MIA92LA128Accident · 2 fatalLimited investigationFinal reportCessna A150L · Cocoa Beach, FLDescent into the ocean for undetermined reasons.NTSB MIA92FA059Accident · 2 fatalField investigationFinal reportCessna 150L · Lake Alfred, FLThe pilot-in-command's inadvertent accelerated stall while buzzing at an altitude that precluded recovery.NTSB CHI91FA302Accident · 2 fatalField investigationFinal reportCessna A150L · Bellaire, MIThe instructor pilot's inadequate supervision which resulted in an inaverent stall and uncontrolled descent into terrain. A related factor is the insufficient altitude.NTSB LAX91FA242Accident · 1 fatalField investigationFinal reportCessna C-A150L · Cottonwood, CAThe pilot's intentional low pass during which he performed an aerobatic maneuver with inadequate airspeed. Contributing factors were the pilot's low altitude and the tailwind condition which created the visual perception to the pilot of having an airspeed…NTSB FTW87LA121Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Olla, LAShortly after takeoff, witnesses observed the acft in a steep climb. Rprtdly, it then entered a left turn & appeared to stall. The plt stated that after about 180 deg of turn, he rolled out, nose low, leveled the wings, then a vibration started. Rprtdly, the…NTSB ATL83FA386Accident · 1 fatalField investigationFinal reportCessna A150L · Ringgold, GAThe acft was observed buzzing a truck stop, partially owned by the plt, at low altitude. The acft then stalled & spun into the ground. Some of the witnesses observed the plt waving & one witness said it appeared that the plt was leaning out the window…NTSB MKC82FCD08Accident · Serious injuriesFinal reportCessna A150L · New Hampton, IAThe aircraft crashed while maneuvering in the vicinity of the pilot/owner's private airfield. The pilot stated that plane went into a 180 deg reverse backslide after he started a left turn and applied left rudder and aileron. He reported that the plane began…