Skip to content

Fatal NTSB investigations: Cessna 150E

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

19652026

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 ('2071812')) 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 ('2071812'))
  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 ('2071812'))
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 ERA19LA037Accident · 1 fatalLimited investigationFinal reportCessna 150 · Woodstock, GAThe pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.Nov 4, 2018 · N3515J · Substantial damage NTSB ERA11FA151Accident · 1 fatalField investigationFinal reportCessna 150E · Ware Shoals, SCThe non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.Feb 19, 2011 · N3022J · Substantial damage NTSB LAX03FA025Accident · 1 fatalField investigationFinal reportCessna 150E · Anaheim Hills, CAthe pilot's continued VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance from power lines. A contributing factor was the pilot's impairment by medication.Nov 8, 2002 · N6236T · Destroyed NTSB FTW01FA025Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXthe failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.Nov 26, 2000 · N6521D · 2 aircraft · Substantial damage NTSB SEA00FA133Accident · 3 fatalField investigationFinal reportCessna 150E · Ashton, IDThe pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…Jul 13, 2000 · N6196T · Destroyed NTSB MIA98FA196Accident · 1 fatalField investigationFinal reportCessna 150E · Panama City Bch, FLThe failure of the pilot to maintain airspeed (Vs) and the inadvertent stall by the pilot. Contributing to the accident was the intentional operation of the airplane by the pilot in an over gross weight condition resulting in a higher stall speed, and failure…Jul 15, 1998 · N3549J · Substantial damage NTSB NYC93FA102Accident · 1 fatalField investigationFinal reportCessna 150E · Selbyville, DEThe pilot's failure to maintain proper airspeed resulting in an inadvertent stall/spin and collision with the terrain. A factor related to the accident was the pilot's lack of experience in the banner towing operation.Jun 7, 1993 · N3981U · Destroyed NTSB CHI90DEM01Accident · 1 fatalFinal reportCessna 150E · Grayling, MIA loss of aircraft control for undetermined reasons.Oct 13, 1989 · N3905U · Destroyed NTSB MIA88FA023Accident · 2 fatalField investigationFinal reportCessna 150E · Aguadilla, PRWitnesses observed the acft maneuvering a low alt over ocean water near a shoreline. They saw it pull up sharply to clear a commercial boat dock, then nose over & impact the water in a nose low, rgt wing low attitude. The acft sank & came to rest in 30' of…Oct 30, 1987 · N4081U · Destroyed NTSB CHI80FA010Accident · 1 fatalClosedCessna 150 · Wilmington, OHNov 25, 1979 · N8820S · Destroyed NTSB IAD77FA046Accident · 1 fatalClosedCessna 150E · Raleigh, NCJun 19, 1977 · N629M · Destroyed NTSB CHI77FA010Accident · 1 fatalClosedCessna 150E · Depere, WIDec 4, 1976 · N3526J · Destroyed NTSB LAX76AL048Accident · 1 fatalClosedCessna 150E · Holbrook, AZJan 25, 1976 · N650LA · Destroyed NTSB MIA75AM003Accident · 1 fatalClosedCessna 150E · Yeehaw Junct, FLJun 26, 1975 · N2595J · Destroyed NTSB MIA74AM006Accident · 3 fatalClosedCessna 150E · Andrews, SCJul 19, 1973 · N2549J · Destroyed NTSB LAX73AL057Accident · 1 fatalClosedCessna 150 · Malibu, CAMay 14, 1973 · N3928U · Destroyed NTSB OAK73AP020Accident · 1 fatalClosedCessna 150 · San Carlos, CAJan 7, 1973 · N6076T · Destroyed NTSB FTW73AF022Accident · 1 fatalClosedCessna 150E · Flatonia, TXDec 1, 1972 · N3034J · Destroyed NTSB DEN72AD016Accident · 2 fatalClosedCessna 150 · Bennett, COSep 25, 1971 · N6117T · Destroyed NTSB IAD70AI048Accident · 1 fatalClosedCessna 150 · Achilles, VAMar 1, 1970 · N3067J · Destroyed NTSB MKC70A0027Accident · 2 fatalClosedCessna 150E · Esmond, ILNov 9, 1969 · N426RA · Destroyed NTSB FTW69A0070Accident · 1 fatalClosedCessna 150E · Placedo, TXApr 8, 1969 · N2555J · Destroyed NTSB NYC69F0144Accident · 1 fatalClosedCessna 150E · Freedom, NHAug 17, 1968 · N631MA · Destroyed NTSB LAX68A0110Accident · 2 fatalClosedCessna 150E · Santa Susana, CAJun 22, 1968 · N3532J · Substantial damage NTSB LAX68A0103Accident · 1 fatalClosedCessna 150 · Casa Grande, AZMay 25, 1968 · N6294T · Destroyed NTSB MKC68A0043Accident · 2 fatalClosedCessna 150E · Hermosa, SDJan 6, 1968 · N4099U · Destroyed NTSB MKC67A0011Accident · 2 fatalClosedCessna 150E · Smithville, MOAug 14, 1966 · N6188T · Destroyed NTSB CHI67A0016Accident · 1 fatalClosedCessna 150 · Racine, WIJul 27, 1966 · N3005J · Destroyed NTSB MIA67A0001Accident · 2 fatalClosedCessna 150E · Dania, FLJul 4, 1966 · N2585J · Destroyed NTSB MIA66A0131Accident · 1 fatalClosedCessna 150 · Lagrange, GAMay 13, 1966 · N3513J · Destroyed NTSB MKC66A0046Accident · 2 fatalClosedCessna 150E · Buffalo, MNFeb 27, 1966 · N3065J · Destroyed NTSB NYC66A0078Accident · 3 fatalClosedPiper PA-28 · Warwick, RIJan 22, 1966 · N5562W · 2 aircraft · Destroyed NTSB NYC66A0055Accident · 1 fatalClosedCessna 150 · Fairfield, NJNov 15, 1965 · N3576J · Destroyed