NTSB investigations: Cessna 150L, 1997
11 cases on aircraft the registry lists as Cessna 150L. 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
| 1970 | 2 |
|---|---|
| 1971 | 35 |
| 1972 | 56 |
| 1973 | 116 |
| 1974 | 153 |
| 1975 | 123 |
| 1976 | 104 |
| 1977 | 95 |
| 1978 | 83 |
| 1979 | 54 |
| 1980 | 59 |
| 1981 | 27 |
| 1982 | 34 |
| 1983 | 28 |
| 1984 | 17 |
| 1985 | 26 |
| 1986 | 27 |
| 1987 | 27 |
| 1988 | 19 |
| 1989 | 28 |
| 1990 | 35 |
| 1991 | 29 |
| 1992 | 29 |
| 1993 | 18 |
| 1994 | 21 |
| 1995 | 18 |
| 1996 | 18 |
| 1997 | 11 |
| 1998 | 21 |
| 1999 | 10 |
| 2000 | 14 |
| 2001 | 16 |
| 2002 | 7 |
| 2003 | 8 |
| 2004 | 7 |
| 2005 | 9 |
| 2006 | 9 |
| 2007 | 10 |
| 2008 | 6 |
| 2009 | 9 |
| 2010 | 6 |
| 2011 | 8 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 8 |
| 2026 | 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\") = 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 ('2071826'))
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 ('2071826'))
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 CHI98LA069Accident · No injuriesLimited investigationFinal reportCessna 150L · Litchfield, MNthe pilot's improper flare and improper recovery from a bounced landing, and his failure to maintain proper runway alignment during the attempted go-around. Factors relating to the accident were: the crosswind condition, and the proximity of trees.NTSB IAD98LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Center Village, OHThe student pilot's improper recovery from a bounced landing.NTSB LAX98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Temple Bar, AZthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the terrain condition (ditch) in the emergency landing area.NTSB NYC97LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Easton, NYmechanical binding of the number three exhaust valve, and the pilot/owner's improper planning/decision by failing to ensure the engine was operating properly before takeoff. A related factor was: the pilot/owner's failure to ensure that annual maintenance was…NTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.NTSB IAD97LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Westfield, MAThe pilot's inadequate preflight preparation which fail to include a weight and balance check and his subsequent failure to maintain aircraft control.NTSB ATL97LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Portland, TNThe pilot's attempt to perform a short field takeoff in unsuitable terrain. A related factor was the pilot's desire to impress his co-workers.NTSB LAX97LA186Accident · No injuriesLimited investigationFinal reportCessna 150 · Groveland, CAwas fuel exhaustion. Contributing to the accident was the lack of preflight review by the student's flight instructor and training.NTSB LAX97LA129Accident · No injuriesLimited investigationFinal reportCessna 150L · Nogales, AZLoss of engine power due to fuel contamination resulting from the pilot's inadequate fuel storage and filtering procedures.NTSB NYC97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarksville, MDThe pilot's failure to maintain directional control and failure to abort the takeoff.NTSB NYC97FA043Accident · 2 fatalField investigationFinal reportCessna 150L · Collegeville, PAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed during the forced landing, which resulted in a stall and collision with the ground. A contributing factor was wind gusts.