NTSB investigations, 2020, FL

8 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2020, FL per year, 2008–2026: 335 cases
200812
200928
201019
201122
201225
201322
201422
201521
201621
201717
201818
201919
20208
202116
202216
20238
202420
202518
20263

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\") = 2020
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA21LA080Accident · 1 fatalClass 3 · LimitedFinal reportSocata TB10 · Pembroke Pines, FLThe pilot’s failure to use carburetor heat in environmental conditions favorable for serious carburetor ice during a prolonged wait with the engine at a low power setting before takeoff, which resulted in a partial loss of engine power due to carburetor ice.…Dec 17, 2020 · N5547Y · DestroyedNTSB ERA21LA071Accident · 1 fatalClass 3 · LimitedFinal reportAnthony Mattioli AR-1 · San Mateo, FLA loss of engine power due to fuel contamination.Dec 12, 2020 · N11TG · Substantial damageNTSB ERA21LA009Accident · Minor injuriesClass 3 · LimitedFinal reportWatson Michael A Velocity Elite RG · Lady Lake, FLA total loss of engine power during cruise flight for undetermined reasons.Oct 6, 2020 · N78BM · Substantial damageNTSB ERA20LA297Accident · 2 fatalClass 3 · LimitedFinal reportRockwell 500 · Pembroke Park, FLA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the fatigue fracture of an electrical wire in the tank unit or fuel transmitter, which likely resulted in an inaccurate fuel quantity indication.Aug 28, 2020 · N900DT · DestroyedNTSB ERA20LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Weston, FLA total loss of engine power due to the failure of the Nos. 1 and 3 connecting rods from lack of lubrication.Aug 27, 2020 · N65645 · Substantial damageNTSB ERA20LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA25 · Miami, FLA total loss of engine power due to carburetor ice that was not detected by the pilot.Aug 5, 2020 · N223AB · Substantial damageNTSB ERA20LA122Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Destin, FLThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Mar 8, 2020 · N581U · Substantial damageNTSB ERA20LA084Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA5 · Tallahassee, FLThe pilot's improper fuel planning, resulting in fuel exhaustion and a total loss of engine power in cruise flight.Jan 21, 2020 · N424WB · Substantial damage