NTSB investigations: Cessna 150L
11 cases on aircraft the registry lists as Cessna 150L, where the sequence of events included Loss of engine power (partial). 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
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2023 | 1 |
| 2024 | 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 ('2071826')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('2071826')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR25LA054Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150L · Glen Avon, OROn December 4, 2024, about 1420 Pacific standard time, a Cessna 150L, N5330Q, sustained substantial damage when it was involved in an accident near Glen Avon, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA23LA297Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Elberton, GAThe pilot’s decision to take off with a known engine issue, which resulted in a partial loss of power on the initial climb due to the No. 1 cylinder’s exhaust valve becoming stuck. Contributing to the outcome, was the pilot’s delay in aborting the takeoff.NTSB ERA16LA116Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAA partial loss of engine power during initial climb for undetermined reasons because examination of the engine and a successful test-run did not reveal any anomalies that would preclude normal operation.NTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR12LA228Accident · No injuriesLimited investigationFinal reportCessna 150L · Tulare, CAA partial loss of engine power, which was likely the result of carburetor icing.NTSB ERA11LA383Accident · No injuriesLimited investigationFinal reportCessna 150L · Plymouth, MAA partial loss of engine power during initial climb due to a stuck cylinder valve, which resulted from excessive corrosion and carbon deposits on the valve springs due to inadequate maintenance.NTSB CEN09FA364Accident · 1 fatalField investigationFinal reportCessna 150L · Rockwall, TXThe pilot’s failure to maintain aircraft control following a loss of engine power due to contamination in the carburetor. Contributing the severity of the accident was the pilot’s failure to utilize his shoulder harness.NTSB CEN09LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Baton Rouge, LAThe partial loss of engine power due to the instructor pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing. Contributing to the accident was the instructor pilot's decision to attempt a return to the departure…NTSB CEN09IA172Incident · No injuriesIncident investigationFinal reportCessna 150 · Grayslake, ILThe failure of the number 1 cylinder intake valve which resulted in a partial loss of engine power. Contributing to the incident was the failure of the operator to maintain the engine per manufacturer's recommendations.NTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…NTSB LAX08LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mesa, AZA partial loss of engine power for undetermined reasons.