NTSB investigations: Cessna 150L
18 cases on aircraft the registry lists as Cessna 150L, where the sequence of events included Off-field or emergency landing. 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 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 3 |
| 2013 | 3 |
| 2014 | 1 |
| 2016 | 4 |
| 2018 | 1 |
| 2021 | 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\" = '440' 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" = '440' 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 ANC25LA005Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Lanai City, HIA partial loss of engine power due to the formation of carburetor ice as a result of the pilot’s improper use of carburetor heat.NTSB ERA21LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Hardwick Township, NJThe pilot’s inadequate prefight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN16LA306Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Russellville, OHA partial loss of engine power due to a fatigue crack of the No. 2 cylinder cooling fin, which resulted in failure of the No. 2 cylinder.NTSB ERA16LA235Accident · No injuriesLimited investigationFinal reportCessna 150 · Peachtree City, GAThe fatigue failure of the No. 3 cylinder exhaust valve, which resulted in a total loss of engine power at low altitude after takeoff.NTSB CEN16LA236Accident · 1 fatalLimited investigationFinal reportCessna 150L · Detroit, MIThe pilot’s disregard of the banner-tow operator's policy regarding the maximum allowable flight duration, which resulted in a total loss of engine power due to fuel exhaustion.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 ERA14LA411Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Creedmoor, NCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s impairment due to alcohol ingestion.NTSB CEN14LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Gladewater, TXThe loss of engine power due to carburetor icing.NTSB ERA14LA048Accident · No injuriesLimited investigationFinal reportCessna 150L · Hopewell, ALA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight inspection and preflight and inflight fuel planning that did not account for increased headwind.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 ERA12LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Punta Gorda, FLThe partial loss of engine power due to contamination of the fuel system that was not detected because of the pilot’s inadequate preflight inspection.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 CEN11LA182Accident · No injuriesLimited investigationFinal reportCessna 150L · Trenton, MIThe loss of preload torque on a connecting rod nut and bolt, which precipitated a separation of the connecting rod from the engine's crankshaft and resulted in the total loss of engine power.NTSB ERA10LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Lake Alfred, FLA loss of engine power during the landing approach for undetermined reasons.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 WPR09CA078Accident · Minor injuriesData collectionFinal reportCessna 150L · Pescadero, CAThe pilot's inadequate preflight fuel planning and preparation. Contributing to the accident was the lack of a suitable area for a forced landing.NTSB CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.