NTSB investigations: Cessna 150J, 1994
11 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\") = 1994
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") = 1994
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 SEA94FA247Accident · 1 fatalField investigationFinal reportCessna 150J · Roseburg, ORthe pilot's failure to maintain clearance from the terrain.NTSB ATL94LA165Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Spruce Pine, NCA seized cylinder exhaust valve because of deposits on the valve and an oversized valve stem. The lack of suitable terrain for a forced landing was a factor.NTSB ANC94LA118Accident · No injuriesLimited investigationFinal reportCessna 150J · Talkeentna, AKThe unsuitable takeoff area selected. A factor was the soft spot in the airstrip's surface.NTSB FTW94LA261Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Dallas, TXThe loss of engine power due to failure of the starter gear and shaft assembly needle bearing. Factors were the dark night conditions and the lack of suitable terrain for a forced landing.NTSB ATL94LA150Accident · No injuriesLimited investigationFinal reportCessna 150J · Waxhaw, NCA loss of engine power due to a stuck, and worn, exhaust valve, and the inadequate inspection of the engine by other maintenance personnel. A factor was the trees at the forced landing area.NTSB FTW94LA255Accident · No injuriesLimited investigationFinal reportCessna 150J · Silver City, NMThe pilot's failure to refuel and the resultant loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB NYC94LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Coatsville, PAThe pilot's inadequate use of carburetor hear. A factor was carburetor icing conditions and soft terrain.NTSB FTW94LA161Accident · No injuriesLimited investigationFinal reportCessna 150J · Del Rio, TXFuel exhaustion induced power loss due to the pilot's inaccurate fuel consumption calculations. The lack of suitable terrain for the forced landing was a factor.NTSB SEA94LA114Accident · No injuriesLimited investigationFinal reportCessna 150K · Chehalis, WAThe pilot's inadequate compensation for wind conditions. A factor to the accident was: crosswind.NTSB CHI94LA135Accident · No injuriesLimited investigationFinal reportCessna 150J · Fredricktown, MOthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB SEA94LA067Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarkston, WAThe pilot in command's inadequate use of carburetor heat. Factor(s) were: carburetor icing weather conditions and rough terrain.