NTSB investigations, 2002, FL

6 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.

Cases per year

19822026
NTSB investigations, 2002, FL per year, 1982–2026: 480 cases
198222
198330
198434
198531
198628
198729
198834
198924
199023
199113
199220
199318
199415
199518
199618
199719
199814
199911
20006
200110
20026
200315
20049
200512
20069
200712

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\" = 353)
  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 ATL03LA012Accident · 1 fatalLimited investigationFinal reportBeech F33A · Fernandina Bch, FLWater contamination in the fuel system which resulted in the loss of engine power and the subsequent collision with trees.Oct 31, 2002 · N3122K · DestroyedNTSB MIA02LA165Accident · Serious injuriesLimited investigationFinal reportCessna T337D · Fort Pierce, FLThe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.Sep 1, 2002 · N33N · Substantial damageNTSB ATL02LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Panama City Bch, FLThe pilot's failure to use carburetor heat that resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.Feb 12, 2002 · N10949 · DestroyedNTSB MIA02LA053Accident · No injuriesLimited investigationFinal reportCessna 182L · Boca Raton, FLThe pilot's failure to perform a proper preflight inspection and refueling of the aircraft, resulting in an in-flight loss of engine power due to fuel exhaustion and a collision with a road sign during the emergency landing.Jan 25, 2002 · N182JM · Substantial damageNTSB MIA02LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lake Placid, FLThe failure of the pilot to perform a proper preflight inspection and his improper fuel tank selection for takeoff, resulting in a loss of engine power on takeoff due to fuel starvation, and the pilot's failure to maintain directional control of the aircraft…Jan 17, 2002 · N201XL · DestroyedNTSB MIA02FA048Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hollywood, FLThe pilot's inadequate planning for a Title 14 CFR Part 135 on-demand air taxi flight, and his failure to refuel the airplane, which resulted in fuel exhaustion while en route over the Atlantic Ocean, a power off glide, and ditching in the ocean.Jan 1, 2002 · N3525Y · Substantial damage