NTSB investigations: Cessna 150H, 1985
8 cases on aircraft the registry lists as Cessna 150H. 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
| 1967 | 3 |
|---|---|
| 1968 | 99 |
| 1969 | 104 |
| 1970 | 93 |
| 1971 | 96 |
| 1972 | 59 |
| 1973 | 39 |
| 1974 | 37 |
| 1975 | 41 |
| 1976 | 18 |
| 1977 | 32 |
| 1978 | 24 |
| 1979 | 16 |
| 1980 | 21 |
| 1981 | 16 |
| 1982 | 14 |
| 1983 | 13 |
| 1984 | 13 |
| 1985 | 8 |
| 1986 | 15 |
| 1987 | 21 |
| 1988 | 6 |
| 1989 | 6 |
| 1990 | 15 |
| 1991 | 9 |
| 1992 | 11 |
| 1993 | 12 |
| 1994 | 6 |
| 1995 | 6 |
| 1996 | 13 |
| 1997 | 7 |
| 1998 | 11 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 6 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 3 |
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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071818'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071818'))
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 LAX86LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · San Andreas, CAThe acft nosed over during a forced landing in a fld aprx 2 miles west of calaveras county arpt. The post-accident wreckage examination disclosed no evidence of fuel in the fuel tanks. The student plt stated that he was on the final leg of a solo x-country…NTSB CHI85LA384Accident · No injuriesLimited investigationFinal reportCessna 150H · Racine, WIThe pilot reported a gust of wind resulted in a nose high left turn just prior to touchdown. Power was added & the left wing contacted the runway. The aircraft went off the left side of the runway and hit a ditch.NTSB LAX85LA359Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Jose, CAThe pilot stated he was on the downwind leg of the traffic pattern when the engine quit. He was unable to glide to the runway and landed in a construction area where the aircraft collided with a dirt pile and flipped over. He further stated that he had flown…NTSB ATL85LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · Enterprise, ALWhile on a solo training flight the aircraft lost power while on downwind and the student pilot made an mergency landing on the runway, however, during landing roll the aircraft went off the side of the rwy and nosed over in the soft soil. Post crash…NTSB LAX85LA273Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Waipahu, HIAprx 1/2 hr into this dual instructional flt the acft struck unmarked high voltage pwr cables, entered an uncontrolled descent and struck the ground. One of the purposes of the flt was to practice emergency apch procedures. Both the instructor and the student…NTSB CHI85LA220Accident · No injuriesLimited investigationFinal reportCessna 150H · Montevideo, MNThe purpose of the flt was to demonstrate the acft to a possible buyer. While taking off, the eng lost power shortly after the acft lifted off at about mid-field. The plt attempted to turn the acft & land on a cross-runway. However, due to his low speed & low…NTSB LAX85FUQ02Accident · No injuriesFinal reportCessna 150H · Sylmar, CAThe acft eng quit during a return from a x-country flt. The plt stated that nearing the end of his flt the acft encountered turbulence over the mts and he climbed to 7500 ft in search of smoother air. Shortly afterwards he started a slow descent from 7500 ft…NTSB BFO85LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150H · South Hill, VAWhile on a solo cross country flight the student pilot became disorientated after about 60MIN of flt. He atmptd to call in the blind on guard. Freq. Both danville and roanok fss's responded to his calls but were unable to establish 2 way commo with the plt.…