NTSB investigations, 2002, FL

5 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.

Cases per year

19822026
NTSB investigations, 2002, FL per year, 1982–2026: 213 cases
19829
198315
19848
198515
198617
19879
198811
198911
199010
19916
19926
19936
19946
199513
19968
19979
19986
19995
20002
20014
20025
20039
20044
20057
20065
20077

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351)
  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 ATL02FA175Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Milton, FLA sheared mixture cable which resulted in a loss of engine power.Sep 23, 2002 · N8828N · Substantial damageNTSB MIA02FA131Accident · 2 fatalField investigationFinal reportAmerican General AA-5 · Boca Raton, FLThe owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.Jul 12, 2002 · N6024L · Minor damageNTSB MIA02LA121Accident · Minor injuriesLimited investigationFinal reportKenneth Parmerter Loehle 5151 Mustang · Lake Placid, FLThe pilot's failure to maintain airspeed and his inflight loss of control while maneuvering to land following an engine failure. Contributing to the accident was the builder/owner's improper engine installation that resulted in engine overheating and ceasing…Jul 4, 2002 · UNREG · Substantial damageNTSB MIA02FA100Accident · No injuriesField investigationFinal reportBell 206L-1 · Fort Lauderdale, FLThe excessive rate of descent by the pilot-in-command during the autorotative landing resulting in a hard landing, following a total loss of engine power caused by failure of the No. 4 bearing.May 24, 2002 · N80PH · Substantial damageNTSB ATL02LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, FLTotal loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…Feb 25, 2002 · N6420M · Substantial damage