NTSB investigations: Cessna 150H, 1993
12 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
Latest 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\") = 1993
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") = 1993
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 LAX94LA059Accident · No injuriesLimited investigationFinal reportCessna 150H · Dardanelle, CAThe pilot misjudged the local weather. The wind conditions and the pilot's inability to compensate for the strong downdraft wind conditions were factors.NTSB CHI94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kansas City, MOLoss of power for an undetermined reason, and the pilot initiating the flight with a rough running engine. Factors related to the accident were: the building and the lack of suitable terrain for a forced landing.NTSB CHI93LA376Accident · No injuriesLimited investigationFinal reportCessna 150H · Gary, INan improper climb airspeed established by the pilot-in-command after banner pickup.NTSB CHI93LA356Accident · No injuriesLimited investigationFinal reportCessna 150H · Crescent, IAImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB FTW93LA253Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Weatherford, TXFuel exhaustion. Factors were: the pilot's failure to have the airplane serviced to capacity prior to departure, and his erroneous fuel consumption calculations.NTSB SEA93LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Garfield, WAThe pilot's improper flare and recovery from a bounced landing. Factors include approach airspeed not maintained, a lack of total experience, and a ditch near the runway.NTSB ATL93LA146Accident · No injuriesLimited investigationFinal reportCessna 150H · Monroe, NCWas the pilot's failure to determine actual fuel consumption enroute. A factor was inadequate supervision by the instructor pilot.NTSB ANC93LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Nondalton, AKThe inadequate preflight preparation by the pilot-in-command. A factor in the accident was the encounter with unsuitable terrain during the emergency descent.NTSB ATL93LA101Accident · No injuriesLimited investigationFinal reportCessna 150H · Lafayette, ALThe pilot's failure to maintain adequate clearance from the mile marker sign during the takeoff roll. A factor was the sign adjacent to the highwayNTSB LAX93LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Diego, CAThe failure of the wing flap control due to the improper type of fuse installed by unidentified persons. Factors relating to this accident were the flap motor partial failure due to corrosion and the total failure of the fuse due to the wrong type amperage.NTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorNTSB MIA93LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Holly Springs, MSThe pilot-in-command's failure to maintain airspeed while maneuvering during a forced landing, resulting in an in-flight loss of control (stall), and subsequent collision with terrain. Contributing to the accident was a total loss of engine power in flight…