NTSB investigations: Cessna 150K
12 cases on aircraft the registry lists as Cessna 150K, 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 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 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 ('2071822')
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 ('2071822')
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 NYC02LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Seaman, OHThe pilot's failure to maintain airspeed during a precautionary landing, which resulted in an inadvertent stall/mush, and uncontrolled descent to the ground. A factor was the pilots' lack of recent experience.NTSB FTW00LA266Accident · No injuriesLimited investigationFinal reportCessna 150K · New Orleans, LAThe pilot's failure to maintain control of the aircraft during an aborted landing. A factor was the crosswind.NTSB ANC00LA014Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Juneau, AKAn inadvertent stall. Factors in the accident were the instructor pilot's excessive angle of climb, and gusty wind conditions.NTSB ATL95LA127Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fairview, TNThe pilot's failure to maintain flying speed during climbout. A factor was the wind gust.NTSB CHI93LA243Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mount Morris, ILThe pilot in command's failure to maintain adequate airspeed.NTSB LAX93LA175Accident · No injuriesLimited investigationFinal reportCessna 150K · Boulder City, NVThe instructor's inadequate bounced landing recovery and airspeed management during the attempted go around, which led to an inadvertent stall and the instructor's inadequate supervision of the flight. A factor in the accident was the instructor's low total…NTSB FTW91FA149Accident · 2 fatalField investigationFinal reportCessna 150K · Waller, TXThe instructor pilot's failure to take remedial action during stall/spin training. Factors were the instructor's overconfidence in his personal ability and the student's apprehension of stalls.NTSB CHI91FA033Accident · 2 fatalField investigationFinal reportCessna 150K · Valley Center, KSContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft after becoming spatially disoriented. Factors related to the accident were: darkness, adverse weather conditions, and the…NTSB BFO91LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Indian Head, MDThe student pilot's failure to maintain adequate aircraft control during the landing flare/touchdown. Contributing factors are his lack of total flight experience and his improper technique when raising flaps during an attempted go-around.NTSB ATL89FA157Accident · 1 fatalField investigationFinal reportCessna 150K · N. Myrtle Beach, SCThe pilot's confusion and diverted attention regarding the multiple banner release system in the cockpit resulting in an inadvertent stall/spin into the terrain from a low altitude. Also causal was the pilot attempting the abrupt maneuver at the low airspeed…NTSB BFO88LA070Accident · No injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEThe plt was in the process of picking up a banner when the aircraft stalled and crashed into a wooded area. The banner was picked up at an airspeed of 80 mph and the acft altitude was increased to 250 ft AGL. The pilot reported that the wings of the acft…NTSB FTW83FA078Accident · 2 fatalField investigationFinal reportCessna 150K · Romayor, TXThe acft spun into the ground from a relatively low alt. The student pilot was giving rides to relatives and had successfully completed one flt during which the acft was stalled followed by a wing over and a dive. These maneuvers were repeated. Estimates of…