Skip to content

Fatal NTSB investigations: Cessna 150C

22 cases on aircraft the registry lists as Cessna 150C. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071808')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071808'))
  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 c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071808'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA18LA048Accident · 1 fatalLimited investigationFinal reportCessna 150 · Castalia, NCThe pilot's exceedance of the airplane's critical angle of attack while performing a turning takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's decision to attempt the takeoff, which he believed…Dec 16, 2017 · N7929Z · Substantial damage NTSB ERA14FA377Accident · 2 fatalField investigationFinal reportCessna 150 · Senoia, GAThe noninstrument-rated pilot’s inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in subsequent collision with terrain.Aug 9, 2014 · N7968Z · Destroyed NTSB ANC04FA042Accident · 2 fatalField investigationFinal reportCessna 150C · DeLand, FLThe pilot's failure to detect water in the fuel system during the preflight inspection, which precipitated a loss of engine power during initial climb, and his failure to maintain adequate airspeed resulting in a stall.Mar 17, 2004 · N2080Z · Destroyed NTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.Sep 23, 1996 · N1947Z · Destroyed NTSB DEN88FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Deer Lodge, MTApr 15, 1988 · N13788 · Destroyed NTSB DEN77FA025Accident · 2 fatalClosedCessna 150C · Reserve, NMFeb 17, 1977 · N7880Z · Destroyed NTSB FTW74AF088Accident · 1 fatalClosedCessna 150G · San Antonio, TXJun 1, 1974 · N2958S · Destroyed NTSB OAK74AP024Accident · 3 fatalClosedCessna 150C · Stockton, CADec 23, 1973 · N7925Z · Destroyed NTSB LAX73AL051Accident · 1 fatalClosedCessna 150 · No.Pacific Ocean (Pacific Ocean)Apr 29, 1973 · N7894Z · Destroyed NTSB LAX72AL035Accident · 2 fatalClosedCessna 150C · Tonopah, AZNov 16, 1971 · N7802Z · Destroyed NTSB OAK68A0069Accident · 1 fatalClosedCessna 150 · Waipahu, HIMay 23, 1968 · N2092Z · Destroyed NTSB SEA67A0059Accident · 1 fatalClosedCessna 150 · Vancouver, WAApr 19, 1967 · N7971Z · Destroyed NTSB LAX66A0075Accident · 1 fatalClosedCessna 150 · ZApr 1, 1966 · N7926Z · Destroyed NTSB CHI66A0009Accident · 1 fatalClosedCessna 150C · Wausau, WIJul 18, 1965 · N7936Z · Destroyed NTSB MIA65A0092Accident · 1 fatalClosedCessna 150G · Auburn, ALMar 14, 1965 · N7966Z · Substantial damage NTSB MIA65A0077Accident · 3 fatalClosedCessna 150 · Americus, GAJan 26, 1965 · N7901Z · Destroyed NTSB UNK65X1163Accident · 1 fatalClosedCessna 150C · Tallahassee, FLDec 27, 1964 · N991KW · Destroyed NTSB UNK65X0252Accident · 2 fatalClosedCessna 150C · Chino, CAOct 12, 1964 · N1905Z · Destroyed NTSB UNK64X2600Accident · 1 fatalClosedCessna 150 · Branford, FLJul 1, 1964 · N1937Z · Destroyed NTSB UNK64X1290Accident · 1 fatalClosedCessna 150 · Solon Springs, WIApr 12, 1964 · N7829Z · Destroyed NTSB UNK64X0566Accident · 1 fatalClosedCessna 150 · Chicago, ILFeb 14, 1964 · N2030Z · Destroyed NTSB UNK64X0241Accident · 1 fatalClosedCessna 150 · Shawnee, OKJan 14, 1964 · N7844Z · Destroyed