NTSB investigations: Cessna 150J, 1986
10 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\") = 1986
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") = 1986
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 NYC87LA048Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenkill, NYThe pilot touched down hard, added power for a go around. Sluggish engine did not have enough power to clear trees at the end of the runway. Aircraft collided with trees. The plt after the acc said that after cutting off the carb head the eng seemed sluggish.…NTSB MKC87LA023Accident · No injuriesLimited investigationFinal reportCessna 150J · Colby, KSThe pilot stated that he departed his private airstrip, low on fuel, intending to refuel at the next stop where he was to conduct a business transaction. Unable to secure fuel there, and showing one quarter of a tank on each fuel gauge, he departed for Colby…NTSB FTW87LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Lago Vista, TXThe instructor (CFI) & student had planned a 30 min flt to practice touch-&-go landings. During the initial climb after the 3rd touch-&-go, the eng lost power from fuel exhaustion. The CFI stated that he measured the fuel supply with a ruler drg the preflt &…NTSB NYC87LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · So. Dayton, NYThe student pilot came in long and high, bounced the aircraft a few times. The nose wheel collpased and the aircraft was substantially damaged.NTSB DEN86LA248Accident · No injuriesLimited investigationFinal reportCessna 150J · Goodrich, NDPlt said he was flying low and chasing black birds from his sunflower fields. Terrain was rolling hills. Plt said he made one pass over field and was turning around for another pass. 'I got my airspeed too low and started to stall. I brought it out of the…NTSB NYC86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Syracuse, NYDuring descent about six miles from Syracuse hancock airport, the flight experienced engine vibration. Engine lost power and restarted. However when flight was at 3500 feet, power was lost again. Pilot set up for best glide and crashed in a grassy field. Full…NTSB LAX86LA191Accident · No injuriesLimited investigationFinal reportCessna 150J · Flagstaff, AZThe pilot was flying a round-robin flight from cottonwood, AZ to page, AZ, and return. The pilot had landed at page, AZ. While on the return leg of the flight the pilot noted his fuel gauges were 'low' and diverted to Flagstaff, AZ. When the acft was…NTSB MIA86LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Boca Raton, FLThe flt experienced a failure of the acft's eng while flying parallel to the beach and the acft was ditched in the atlantic ocean. Inspection of the acft after recovery revealed the foam air cleaner had been drawn into the carburetor air box and was blocking…NTSB DEN86LA106Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Tioga, NDThe plt dept minot, ND, with his son aboard, for a pvt airstrip near his home of windrose, ND. He said because of high winds he landed at Tioga, ND. He said that while taxiing after landing strong gusty winds flipped his acft upside down. The acft was…NTSB LAX86LA124Accident · No injuriesLimited investigationFinal reportCessna 150J · Los Banos, CAThe pilot stated that he overflew his destination airport while on a night cross-country flight. He turned around and was proceeding back when the engine quit 20 miles short of his intended destination. The aircraft hit a ditch during the ensuing forced…