Fatal NTSB investigations: NONE, FL

10 cases on aircraft whose registry engine model is NONE. 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

19742026
Fatal NTSB investigations: NONE, FL per year, 1974–2026: 10 cases
19741
19771
19801
19851
19871
19891
19921
20181
20201
20221

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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
  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.

NTSB ERA22FA189Accident · 1 fatalClass 3 · FieldFinal reportSchleicher ASW-19B · Jacksonville, FLThe pilot’s improper preflight assembly of the glider’s elevator control, which resulted in a loss of control on takeoff, and the pilot’s failure to complete a positive control check before the flight, which would have identified the disconnected elevator…Apr 16, 2022 · N19KW · Substantial damageNTSB ERA20LA145Accident · 1 fatalClass 3 · LimitedFinal reportSchempp Hirth Standard Cirrus · Groveland, FLThe pilot’s exceedance of the glider’s critical angle of attack following his premature termination of the tow for reasons that could not be determined, which resulted in an aerodynamic stall/spin during a turn back to the departure airport.Apr 7, 2020 · N271BL · Substantial damageNTSB ERA18FA128Accident · 1 fatalField investigationFinal reportS.Z.D. SZD 48 Jantar STD 2 · LaBelle, FLThe pilot's failure to maintain control of the glider for reasons that could not be determined based on the available evidence.Apr 14, 2018 · N456RM · Substantial damageNTSB MIA92LA145Accident · 1 fatalLimited investigationFinal reportRaven S-60A · Dover, FLThe pilot in commands choice of landing area near electrical lines and his failure to exit the balloon and seek safety when it was determined the deflating bag was going to make contact with power lines resulting in his receiving electrocution injuries.Jul 4, 1992 · N4037Q · Minor damageNTSB MIA90FA008Accident · 1 fatalField investigationFinal reportMcdonnell Douglas DC-9-31 · Orlando, FLInadequate weather evaluation and inadequate supervision of the ground guide (mechanic) by company/operator/management personnel, failure of the ground guide to follow safety procedures, and the weather condition (lightning).Oct 7, 1989 · N958VJ · No damageNTSB MIA88FA008Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau 230 · Arcadia, FLThe accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the…Oct 17, 1987 · N230WF · DestroyedNTSB MIA85FA143Accident · 1 fatalField investigationFinal reportBalloon Works Firefly 7B · Orlando, FLThe Balloon was destroyed by an explosion and subsequent fire during touchdown in an open fld. The plt and witnesses stated the gondola touched down with a 'jolt' and tilted in the direction of travel. Shortly thereafter, a popping noise was heard followed by…Apr 7, 1985 · N36938 · DestroyedNTSB MIA81FLD07Accident · 1 fatalClosedTern II · Ocoee, FLNov 1, 1980 · N2918 · DestroyedNTSB MIA78FA008Accident · 2 fatalClosedLet-Np-K L-13 · Pensacola, FLOct 27, 1977 · N779 · DestroyedNTSB MIA75AM006Accident · 2 fatalClosedRaven S-60A · Tavares, FLJul 9, 1974 · N54691 · Minor damage