NTSB investigations: Cessna 150F, 1997
13 cases on aircraft the registry lists as Cessna 150F. 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
| 1965 | 34 |
|---|---|
| 1966 | 229 |
| 1967 | 264 |
| 1968 | 172 |
| 1969 | 124 |
| 1970 | 81 |
| 1971 | 68 |
| 1972 | 62 |
| 1973 | 49 |
| 1974 | 50 |
| 1975 | 38 |
| 1976 | 28 |
| 1977 | 18 |
| 1978 | 26 |
| 1979 | 24 |
| 1980 | 21 |
| 1981 | 20 |
| 1982 | 9 |
| 1983 | 6 |
| 1984 | 15 |
| 1985 | 12 |
| 1986 | 15 |
| 1987 | 14 |
| 1988 | 25 |
| 1989 | 8 |
| 1990 | 15 |
| 1991 | 6 |
| 1992 | 14 |
| 1993 | 7 |
| 1994 | 6 |
| 1995 | 8 |
| 1996 | 14 |
| 1997 | 13 |
| 1998 | 11 |
| 1999 | 11 |
| 2000 | 8 |
| 2001 | 4 |
| 2002 | 8 |
| 2003 | 8 |
| 2004 | 4 |
| 2005 | 8 |
| 2006 | 4 |
| 2007 | 2 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 6 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 5 |
| 2025 | 8 |
| 2026 | 1 |
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 ('2071814'))
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 ('2071814'))
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 FTW98LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Brigham City, UTfailure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.NTSB ATL97LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Kenly, NCThe pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.NTSB CHI97FA208Accident · 1 fatalField investigationFinal reportCessna 150F · Gary, INthe pilot's not obtaining/maintaining airspeed which resulted in a stall.NTSB MIA97LA200Accident · No injuriesLimited investigationFinal reportCessna 150F · Clearwater, FLthe student pilot's inadequate compensation for wind conditions during an attempted go-around, which resulted in an on-ground loss of control and subsequent collision with trees and a ditch. The crosswind, trees, and ditch were related factors.NTSB LAX97LA256Accident · No injuriesLimited investigationFinal reportCessna 150F · Casa Grande, AZFailure of the student pilot to maintain directional control.NTSB IAD97LA090Accident · No injuriesLimited investigationFinal reportCessna 150 · Punxsutawney, PAPilot in command became disoriented and continued flight until fuel exhaustion. A factor to this accident is the pilot's inadequate in-flight planning/decision by over flying several airports during his disorientation.NTSB MIA97LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Venice, FLfailure of the pilot to maintain sufficient airspeed on final approach and during the landing to properly flare the airplane.NTSB SEA97LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTThe pilot's failure to adequately compensate for wind conditions during the landing roll. Factors contributing to the accident were gusts and crosswinds.NTSB NYC97LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lehighton, PAreplacement of the flap actuating system fuse by the pilot-in-command with the flap actuating handle in the fully retracted position. This resulted in the retraction of the flaps, an inadvertent stall/mush, and the subsequent in-flight collision with terrain.NTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.NTSB CHI97LA089Accident · No injuriesLimited investigationFinal reportCessna 150 · Petersburg, INThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Low altitude flight is a contributing factor.NTSB ATL97LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLthe student pilot's inadvertent movement of the mixture control to idle cut-off during the approach to land, which resulted in engine shut-down, and the student's failure to follow emergency procedures for restarting the engine.NTSB IAD97FA038Accident · 1 fatalField investigationFinal reportCessna 150F · Bittinger, MDVFR flight by the noninstrumented-rated pilot into instrument meteorological conditions (IMC), which lead to spatial disorientation of the pilot, his loss of aircraft control, and an uncontrolled collision with the terrain. Factors relating to the accident…