NTSB investigations: Cessna 150, 1992
7 cases on aircraft the registry lists as Cessna 150. 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 | 61 |
|---|---|
| 1965 | 41 |
| 1966 | 53 |
| 1967 | 28 |
| 1968 | 28 |
| 1969 | 25 |
| 1970 | 20 |
| 1971 | 15 |
| 1972 | 23 |
| 1973 | 24 |
| 1974 | 16 |
| 1975 | 16 |
| 1976 | 11 |
| 1977 | 15 |
| 1978 | 8 |
| 1979 | 4 |
| 1980 | 6 |
| 1981 | 2 |
| 1982 | 6 |
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 4 |
| 1989 | 6 |
| 1990 | 2 |
| 1991 | 6 |
| 1992 | 7 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 5 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 4 |
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2018 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 3 |
| 2025 | 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 year(c.\"eventDate\") = 1992
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071802'))
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") = 1992
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071802'))
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 DEN92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greeley, COTotal loss of engine power due to a deteriorated carburetor float which resulted in engine flooding. A factor was: unsuitable terrain for a forced landing.NTSB NYC92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Farmington, MDThe pilot's improper level off which resulted in a hard landing. Contributing was an inadeuate recovery from a bounced landing, and the pilot's lack of total flight experience.NTSB SEA92FA148Accident · 1 fatalField investigationFinal reportCessna 150 · Burns, ORThe failure of the pilot to maintain clearance from wires on a 500 kv electrical power transmission line.NTSB CHI92LA166Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOThe flight instructor's delay in initiating a go-around and improper recovery from the student's bounced landing. Factor(s) which contributed to the accident was the student pilot overshooting the approach.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 LAX92FA135Accident · 2 fatalField investigationFinal reportCessna 150 · Williams, AZThe pilot inadequately evaluating the weather condition, and the pilot's inflight decision to continue flight into adverse weather conditions. Factors in this accident were the pilot's visual lookout ability being restricted by the prevailing weather…NTSB FTW92FA073Accident · Serious injuriesField investigationFinal reportCessna 150 · Clarksville, ARThe pilots inadvertent stall. A factor was the operator's inadequate supervision.