NTSB investigations: Cessna 150J, 1997
7 cases on aircraft the registry lists as Cessna 150J. 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
| 1966 | 1 |
|---|---|
| 1968 | 6 |
| 1969 | 55 |
| 1970 | 101 |
| 1971 | 72 |
| 1972 | 72 |
| 1973 | 52 |
| 1974 | 52 |
| 1975 | 30 |
| 1976 | 47 |
| 1977 | 29 |
| 1978 | 27 |
| 1979 | 25 |
| 1980 | 11 |
| 1981 | 19 |
| 1982 | 13 |
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 10 |
| 1987 | 15 |
| 1988 | 24 |
| 1989 | 10 |
| 1990 | 18 |
| 1991 | 19 |
| 1992 | 7 |
| 1993 | 15 |
| 1994 | 11 |
| 1995 | 11 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 3 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 1 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 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\") = 1997
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071820'))
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") = 1997
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071820'))
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 SEA98LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Silverdale, WAIce accumulation in the carburetor throat. Factors include conditions conducive to serious carburetor icing, an inoperative starter due to a separated pull-to-start knob, and soft terrain at the location of the forced landing.NTSB CHI98LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Plymouth, INthe pilot's failure to maintain control of the airplane during the crosswind, soft field takeoff. Factors in this accident were the pilot not following the airplane manufacturer's recommended takeoff procedures by lowering the flaps, and the crosswind.NTSB CHI97LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Romeo, MIthe pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.NTSB CHI97LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodbine, IAThe pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.NTSB MIA97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Miami, FLThe student pilot's inadequate preflight planning and improper fuel consumption calculations which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA088Accident · No injuriesLimited investigationFinal reportCessna 150J · La Valle, WIthe pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.NTSB SEA97LA064Accident · No injuriesLimited investigationFinal reportCessna 150J · Price, UTThe flight instructor's failure to ensure that the dual student maintained adequate airspeed.