NTSB investigations: Cessna 150L
18 cases on aircraft the registry lists as Cessna 150L, where the first occurrence was “Loss of engine power(partial) - 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 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 3 |
| 1994 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 354))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 354))
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 LAX07CA287Accident · No injuriesData collectionFinal reportCessna 150L · Woodland, WAa partial loss of engine power due to carburetor icing conditions.NTSB MIA03LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Powells Point, NCa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB IAD01LA083Accident · No injuriesLimited investigationFinal reportCessna 150L · Lusby, MDThe student pilot's improper use of carburetor heat.NTSB NYC00LA262Accident · No injuriesLimited investigationFinal reportCessna 150L · Salem, OHA partial power loss for undetermined reasons.NTSB MIA00LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Statesboro, GAThe partial loss of engine power due to undetermined reasons and unsuitable terrain encountered by the pilot-in-command (CFI), during the forced landing.NTSB CHI94LA183Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bolivar, MOThe partial blockage of the carburetor's induction air opening by a plastic bag.NTSB NYC92LA169Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Put-In-Bay, OHThe pilot's improper use of carburetor heat, resulting in a loss of engine power and subsequent forced landing in trees.NTSB NYC92LA109Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAThe student pilot's delayed action in applying carburetor heat during cruise, which resulted in a loss of engine power due to carburetor ice. Factors in this accident were: weather conditions conducive for carburetor icing, the pilot's lack of total flying…NTSB SEA92LA052Accident · No injuriesLimited investigationFinal reportCessna 150L · Mulino, ORCarburetor ice and improper use of the carburetor heat. Factors to the accident were: carburetor icing conditions and an inadequate weather evaluation.NTSB LAX91LA216Accident · No injuriesLimited investigationFinal reportCessna C-150L · Groveland, CAThe pilots neglect to calculate the aircrafts fuel consumption and his failure to service the aircraft with fuel prior to the last takeoff. The wire across the aircrafts flight path during the forced landing was a factor in the accident.NTSB MIA91LA110Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Quincy, FLThe pilot's inadequate preflight.NTSB LAX90LA256Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Santa Catalina, CAThe engine failure due to carburetor ice and the pilots improper use of carburetor heat.NTSB DEN88LA060Accident · No injuriesLimited investigationFinal reportCessna 150L · Reynolds, NDNTSB ANC86LA090Accident · No injuriesLimited investigationFinal reportCessna 150 · Talkeetna, AKThe student pilot, who was carrying a passenger, mixed automotive fuel with aviation gasoline. The auto gas contained water causing the engine to run intermittently. The airplane turned over during a forced landing in a swamp. Post accident inspection rvealed…NTSB BFO86FA029Accident · Minor injuriesField investigationFinal reportCessna 150L · Upper Marlboro, MDThe acft made a forced landing after the eng began to overheat during cruise flt about 20 minutes after departure. The plt stated that as soon as he smelled the oil heating up he knew what the problem was. He had not removed the foam plugs from the air…NTSB DEN85LA063Accident · No injuriesLimited investigationFinal reportCessna 150 · Missoula, MTOn jan 14, 1985, a Cessna 150 nosed over after landing on a highway near Missoula, MT. The pilot stated he lost partial engine power due to carburetor icing conditions encountered enroute from great falls, MT. The pilot and his passenger were not injured. The…NTSB LAX83LA059Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Big Bear Lake, CAThe acft descended into trees after a non-mechanical engine failure on a night takeoff. The wx was foggy with visibilityless than 100 yards. The elevation was 6,750 ft MSL. It is not known whether the plt appled carburetor heat. The control was broken off at…NTSB ATL82DA232Accident · No injuriesFinal reportCessna 150 · Horrell Hill, SCPilot making touch and go landings at private airstrip. After takeoff aircraft would not maintain altitude. Pilot made an emergency landing in a bean field. Aircraft flipped over. Pilot forgot to retract full flaps and carb heat was on during takeoff.