NTSB investigations: Cessna 150G, 1989
8 cases on aircraft the registry lists as Cessna 150G. 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
| 1964 | 1 |
|---|---|
| 1966 | 26 |
| 1967 | 154 |
| 1968 | 122 |
| 1969 | 114 |
| 1970 | 83 |
| 1971 | 78 |
| 1972 | 57 |
| 1973 | 47 |
| 1974 | 30 |
| 1975 | 41 |
| 1976 | 36 |
| 1977 | 22 |
| 1978 | 26 |
| 1979 | 22 |
| 1980 | 24 |
| 1981 | 12 |
| 1982 | 14 |
| 1983 | 15 |
| 1984 | 12 |
| 1985 | 14 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 10 |
| 1989 | 8 |
| 1990 | 16 |
| 1991 | 15 |
| 1992 | 11 |
| 1993 | 13 |
| 1994 | 6 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 9 |
| 1999 | 10 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 3 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 1989
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
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 year(c."eventDate") = 1989
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
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 MIA89LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Marathon, FLThe pilot's misjudgement of clearance between his aircraft and the parked aircraft. Factors related to the accident were: sunglare and the location of the parked aircraft.NTSB ATL89LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Edgefield, SCPoor inflight planning by the pilot in command in that he allowed the fuel supply to be exhausted.NTSB FTW89DRJ01Accident · Serious injuriesFinal reportCessna 150 · Piedmont, OKThe pilot's failure to maintain adequate airspeed while buzzing, which resulted in an inadvertent stall.NTSB DEN89LA180Accident · No injuriesLimited investigationFinal reportCessna 150G · West Jordan, UTInadequate preflight by the pilot, which resulted in fuel exhaustion, due to his misjudgement of the fuel supply. Factors related to the accident were: a false fuel gage indication, and the ditch in the emergency landing area.NTSB CHI89LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Iola, WIThe improper preflight planning by the pilot in command resulting in the airplane fuel quantity being near the unusable quantity which resulted in total loss of engine power due to fuel starvation while maneuvering. Contributing to the accident was the pilots…NTSB ANC89LA113Accident · No injuriesLimited investigationFinal reportCessna 150 · Duffys Tavern, AKThe selection of the soft sandy strip for takeoff by the pilot and his premature liftoff combined to make it impossible to attain climb airspeed before colliding with bushes at the end of the runway.NTSB MKC89LA086Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Papillion, NEThe contamination of the fuel screen by foreign matter and operation of the aircraft with known deficiencies.NTSB ATL89LA094Accident · No injuriesLimited investigationFinal reportCessna 150G · Springboro, OHLoss of power (takeoff) from carburetor ice due to improper use of carburetor heat during extended ground operation using auto fuel in weather which was conducive to icing.