Skip to content

NTSB investigations: Cessna 150E, FL

27 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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  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 ATL98LA124Accident · No injuriesLimited investigationFinal reportCessna 150E · Bradenton, FLThe loss of engine power for undetermined reasons.Sep 12, 1998 · N6080T · Substantial damage 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 MIA95LA234Accident · No injuriesLimited investigationFinal reportCessna 150 · Sarasota, FLThe failure of the pilot to perform fuel consumption calculations resulting in a loss of power due to fuel exhaustion.Sep 24, 1995 · N6080T · Substantial damage NTSB MIA93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Blountstown, FLInadequate visual lookout by the pilot resulting in failure to avoid the powerline.Feb 27, 1993 · N3064J · Substantial damage NTSB MIA86LA207Accident · No injuriesLimited investigationFinal reportCessna 150E · Wakulla Springs, FLThe plt stated that while on final approach, the airspeed was too fast. When the acft touched down it began to porpoise, he lost control and the acft flipped over and came to rest inverted.Jul 12, 1986 · N6234T · Substantial damage NTSB MIA79FKT46Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLMar 15, 1979 · N3936U · Substantial damage NTSB MIA75AM003Accident · 1 fatalClosedCessna 150E · Yeehaw Junct, FLJun 26, 1975 · N2595J · Destroyed NTSB MIA74FLD79Accident · Serious injuriesClosedCessna 150 · Forest Lake, FLMar 28, 1974 · N3503J · Destroyed NTSB MIA73DKT35Accident · No injuriesClosedCessna 150 · Belle Glade, FLDec 9, 1972 · N4015U · Substantial damage NTSB MIA72FLD02Accident · No injuriesClosedCessna 150 · St.Petersburg, FLJul 13, 1971 · N3524J · Substantial damage NTSB MIA70DLA25Accident · No injuriesClosedCessna 150 · Tallahassee, FLJun 20, 1970 · N6208R · Substantial damage NTSB MIA69D0142Accident · No injuriesClosedCessna 150 · Opa Locka, FLSep 15, 1968 · N3540J · Substantial damage NTSB MIA68D0153Accident · No injuriesClosedCessna 150 · Homestead, FLSep 1, 1967 · N4002U · Substantial damage NTSB MIA68F0012Accident · No injuriesClosedCessna 150 · Hollywood, FLMay 31, 1967 · N6254T · Substantial damage NTSB MIA67D0546Accident · No injuriesClosedCessna 150 · Pompano Beach, FLApr 29, 1967 · N3076J · Substantial damage NTSB MIA67F0420Accident · No injuriesClosedCessna 150 · Opa Locka, FLMar 11, 1967 · N3540J · Substantial damage NTSB MIA67D0411Accident · No injuriesClosedCessna 150 · Opa Locka, FLFeb 22, 1967 · N3991U · Substantial damage NTSB MIA67D0208Accident · No injuriesClosedCessna 150 · Davie, FLOct 13, 1966 · N4092U · Substantial damage NTSB MIA67F0059Accident · No injuriesClosedCessna 150 · St Petersburg, FLJul 14, 1966 · N3578J · Substantial damage NTSB MIA67D0006Accident · No injuriesClosedCessna 150 · Boca Raton, FLJul 14, 1966 · N4002U · Substantial damage NTSB MIA67D0050Accident · No injuriesClosedCessna 150 · Homestead, FLJul 12, 1966 · N3973U · Substantial damage NTSB MIA67A0001Accident · 2 fatalClosedCessna 150E · Dania, FLJul 4, 1966 · N2585J · Destroyed NTSB MIA66F0490Accident · No injuriesClosedCessna 150 · Ormond Beach, FLMar 30, 1966 · N3001J · Substantial damage NTSB MIA66D0515Accident · Minor injuriesClosedCessna 150 · Bunnell, FLSep 24, 1965 · N3001J · Substantial damage NTSB MIA66F0210Accident · No injuriesClosedCessna 150 · Jacksonville, FLSep 1, 1965 · N6155T · Destroyed NTSB MIA65F0051Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLApr 13, 1965 · N2554J · Substantial damage NTSB UNK65X1388Accident · No injuriesClosedCessna 150 · Opa Locka, FLFeb 3, 1965 · N3076J · Substantial damage