NTSB investigations: Cessna 150M, 1997
16 cases on aircraft the registry lists as Cessna 150M. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 6 |
| 1975 | 43 |
| 1976 | 72 |
| 1977 | 123 |
| 1978 | 104 |
| 1979 | 84 |
| 1980 | 57 |
| 1981 | 48 |
| 1982 | 53 |
| 1983 | 40 |
| 1984 | 40 |
| 1985 | 28 |
| 1986 | 31 |
| 1987 | 38 |
| 1988 | 32 |
| 1989 | 39 |
| 1990 | 34 |
| 1991 | 27 |
| 1992 | 26 |
| 1993 | 30 |
| 1994 | 32 |
| 1995 | 27 |
| 1996 | 26 |
| 1997 | 16 |
| 1998 | 22 |
| 1999 | 31 |
| 2000 | 17 |
| 2001 | 10 |
| 2002 | 7 |
| 2003 | 9 |
| 2004 | 9 |
| 2005 | 12 |
| 2006 | 9 |
| 2007 | 12 |
| 2008 | 9 |
| 2009 | 2 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 11 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 6 |
| 2025 | 4 |
| 2026 | 2 |
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 ('2071830'))
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 ('2071830'))
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 CHI98LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Sidney, NEthe student pilot's inadequate compensation for the crosswind which resulted in a loss of directional control. Factors associated with the accident were the crosswind, the misunderstood radio communication, and the rough terrain which the airplane encountered.NTSB FTW98LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Tajique, NMThe loss of engine power due to carburetor ice. Factors included unsuitable terrain, and dark night conditions.NTSB MIA98LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLa loss of engine power for undetermined reasons.NTSB FTW98LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · San Antonio, TXinadequate service provided by the ground controller, by clearing the Boeing 727 to taxi after the Cessna 150 was cleared to taxi behind the 727, which led to a wake turbulence (jet exhaust) encounter and damage to the Cessna 150.NTSB FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.NTSB ATL98LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Miami, FLexcessive wear to the number one valve stem and valve stem keepers that resulted in the separation of the valve assembly.NTSB NYC98LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Georgetown, DEThe student pilot's improper recovery from the bounced landing and the flight instructor's delayed remedial action.NTSB CHI97LA296Accident · No injuriesLimited investigationFinal reportCessna 150M · Salem, ILthe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI97LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Benton, KSthe flight instructor's (CFI') improper in-flight planning/decision, which led to fuel exhaustion and loss of engine power before the airplane was safely landed.NTSB SEA97LA183Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, IDThe pilot's failure to attain rotation speed. The pilot's failure to maintain aircraft control and rough runway conditions were factors.NTSB CHI97LA236Accident · No injuriesLimited investigationFinal reportCessna 150M · Lee'S Summit, MOthe pilot's inadequate preflight planning/preparation, and his failure to ensure that the airplane remained clear of obstrictions (trees). Factors associated with the accident were: the short runway/takeoff area, and the proximity of trees.NTSB IAD97LA103Accident · No injuriesLimited investigationFinal reportCessna 150M · Ocean City, NJInadequate compensation for the crosswind, and failure to maintain control of the airplane. A related factor was the crosswind.NTSB LAX97LA251Accident · No injuriesLimited investigationFinal reportCessna 150M · Chico, CAfailure of the student pilot to maintain adequate airspeed during a go-around. Trees at the departure end of the runway were a related factor.NTSB MIA97LA140Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe flight crew's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion.NTSB ATL97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Raleigh, NCa loose fuel capd and siphoning of fuel, resulting in fuel exhaustion and a loss of engine power. A factor was the rough terrain in the forced landing field that resulted in the nose over during the landing roll.NTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.