NTSB investigations: Cessna 150
15 cases on aircraft the registry lists as Cessna 150, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 2 |
|---|---|
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Latest 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 ('2071802')
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\" = 353))
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 ('2071802')
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" = 353))
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 NYC07CA154Accident · No injuriesData collectionFinal reportCessna 150 · Lancaster, PAThe pilot's decision to conduct the flight while impaired by alcohol, which resulted in fuel exhaustion and substantial damage to the airplane during the subsequent forced landing.NTSB SEA06LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · White Salmon, WAThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. Contributing factors were the inadequate preflight by the pilot, and the airplane's fuel contamination by water.NTSB FTW04LA116Accident · No injuriesLimited investigationFinal reportCessna 150 · Magnolia, ARThe pilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL03LA149Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Beaufort, NCLoss of engine power due to undetermined reasons.NTSB LAX01TA233Accident · No injuriesFinal reportCessna 150 · Delano, CAA bent mixture control valve stem shaft in the carburetor which made pilot control of the mixture inoperative resulting in excessive fuel consumption, and subsequent loss of engine power..NTSB SEA94LA053Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, ORFuel exhaustion, and the pilot's poor inflight decision. Factors include the pilot's poor pre-flight planning, and a sign in the path of the landing roll.NTSB LAX94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Daggett, CAthe pilot's poor fuel consumption calculations which culminated in engine losing power due to fuel exhaustion. The soft desert terrain was a factor in this accident.NTSB LAX92FA212Accident · 2 fatalField investigationFinal reportCessna 150 · Cottonwood, AZA failure of the student pilot to conduct an adequate pre-flight inspection to remove contaminated fuel; a failure to maintain adequate airspeed to prevent an inadvertent stall. Contributing to the accident was an inadequate annual inspection of the fuel…NTSB FTW89LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Terrell, TXThe pilot became lost during the flight and fuel exhaustion occurred which required an off airport forced landing.NTSB LAX89LA228Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelseyville, CAInadequate preflight planning/preparations and the improper fuel consumption calculations by the pilot.NTSB CHI88DEC03Accident · Minor injuriesFinal reportCessna 150 · Jackson, MITotal loss of engine power due to carburetor icing.NTSB LAX88LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Redbluff, CADuring a cross country flt, the engine experienced a complete pwr loss. The plt made a forced landing where the acft collided with the terrain 1 mile short of the rwy. Inspection of the acft revealed that the fuel tanks were near empty. There were no reported…NTSB FTW87LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Loreauville, LAA private pilot substantially damaged his aircraft while attempting a landing in a field following a engine failure due to water contamination in the fuel system.NTSB MIA82DA159Accident · No injuriesFinal reportCessna 150 · Englewood, FLAs the pilot was climbing through about 700 ft MSL, he observed a person on the beach waving at his aircraft. He thought the person was someone he knew so had made a descending turn to 500 ft to take a better look. When he determined that it was the wrong…NTSB CHI82DA137Accident · No injuriesFinal reportCessna 150 · Blaine, MNWhile on final approach the pilot stated that the engine lost power. The aircraft landed about 700 feet short of the runway in rough terrain. Investigation disclosed at least 1 1/2 pints of water in the left fuel tank, water in the carburetor bowl, and the…