NTSB investigations: Cessna 150G
12 cases on aircraft the registry lists as Cessna 150G, 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
| 1984 | 2 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1996 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2006 | 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 ('2071816')
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 ('2071816')
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 DFW06CA119Accident · No injuriesData collectionFinal reportCessna 150G · Coleman, TXThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.NTSB NYC99LA212Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, OHThe pilot's delay in using carburetor heat which resulted in a partial loss of engine power, and a forced landing.NTSB SEA96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Vancouver, WAthe pilot's failure to use carburetor heat, and his delay in aborting the takeoff after noting sluggish acceleration. Factors were: the carburetor icing conditions, the trees off the end of the runway, and the soft ground conditions in the forced landing area.NTSB ANC93LA011Accident · No injuriesLimited investigationFinal reportCessna 150G · Delta Junction, AKThe pilot in command's (CFI) in flight planning/decision to attempt a down wind forced landing in high surface wind conditions and the pilot's improper use of carburetor heat.NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.NTSB LAX92LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Sacramento, CAThe failure of the CFI to properly use carburetor heat in conditions conducive to the formation of carburetor ice. Factors in this accident were: 1) weather conditions conducive to carburetor icing and 2) the lack of suitable terrain to complete the forced…NTSB FTW91LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Hitchcock, TXA power loss for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the forced landing. Factors were the pilot's continued operation with a known engine deficiency and the owner/operator's failure to perform needed maintenance.NTSB MIA90LA124Accident · No injuriesLimited investigationFinal reportCessna 150G · Marianna, FLThe pilot's delay in the application of carburetor heat. The carburetor icing condition was a related factor.NTSB NYC88LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westerly, RIThe plt reported that he experienced a power loss at 350 ft AGL after takeoff. He turned back toward the airport but had insufficient altitude. He elected to land off-airport at an industrial site with the stall warning horn sounding. During landing roll, the…NTSB FTW84LA281Accident · No injuriesLimited investigationFinal reportCessna 150G · Ennis, TXAfter the plt experienced a rough running eng while doing touch & go landings he executed a precautionary ldg. Upon rollout the acft nosed over in a ditch & came to rest inverted. Post crash examination of the eng revealed no evidence of a mechanical failure…NTSB CHI84LA079Accident · No injuriesLimited investigationFinal reportCessna 150G · Plato Center, ILThe acft nosed over during a forced landing after the engine lost power. After the accident oil samples from the acft were analyzed and found to contain anti-freeze. The acft owner suspected sabotage.