NTSB investigations: NONE, 1986, FL

4 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

19642026
NTSB investigations: NONE, 1986, FL per year, 1964–2026: 87 cases
19641
19651
19681
19692
19732
19743
19765
19775
19782
19792
19803
19821
19832
19842
19853
19864
19873
19881
19892
19912
19921
19932
19943
19951
19961
19972
19982
19991
20006
20021
20031
20051
20061
20071
20091
20102
20121
20132
20172
20183
20201
20211
20221
20242

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\") = 1986
    AND 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.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 MIA87LA030Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Brandon, FLA high sink rate was not arrested prior to the hard ldg. The plt stated that he briefed the pax on ldg procedures which included a tight grip in the event of an emerg ldg. The pax statements differed from those of the Balloon crew concerning the content of…Nov 4, 1986 · N37171 · No damageNTSB MIA86LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Lauderdale, FLWhile towing a banner near the beach the aircraft's engine failed. The aircraft was ditched in the atlantic ocean and the pilot swam to shore. The pilot stated he became distracted watching the boats and failed to switch fuel tanks causing the right fuel tank…Apr 26, 1986 · N2411P · Substantial damageNTSB MIA86LA128Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Alachua, FLThe plt stated the he decided to land because the wind had picked up during the flt. Upon landing the gondola tipped over resulting in himself and one passenger falling on top of the other passenger, who received a fractured leg.Apr 20, 1986 · N10600 · No damageNTSB MIA86LA070Accident · No injuriesLimited investigationFinal reportLet L-13 · Brooksville, FLThe pilot stated that he encountered sinking air & was unable to make the arpt. He also stated that he was operating east of the arpt & that a seabreeze wind from the west existed at the time of the accident. The effective glide ratio of a glider is reduced…Feb 2, 1986 · N26TS · Substantial damage