NTSB investigations, 2002, FL

14 cases where the first occurrence was “Loss of engine power”.

Cases per year

19822026
NTSB investigations, 2002, FL per year, 1982–2026: 398 cases
198224
198312
198410
198514
198615
198715
198812
19897
199011
199120
19929
199318
199413
19957
199619
199721
199826
199922
200018
200118
200214
20038
200418
200518
200614
200715

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\" = 350)
  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 MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.Oct 22, 2002 · N5247A · Substantial damageNTSB ATL03LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe loss of engine power for undetermined reasons.Oct 13, 2002 · N6542J · Substantial damageNTSB MIA03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Immokalee, FLA loss of engine power on takeoff for undetermined reasons.Oct 8, 2002 · N7014Y · Substantial damageNTSB MIA02IA160Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB BK-117 A4 · Bradenton, FLImproper maintenance/installation of the No. 2 engine power turbine (PT) wheel assembly by company maintenance personnel, which resulted in deflection at the engine case axial midpoint and misalignment between the inlet housing and the rear bearing support…Aug 27, 2002 · N528SF · Minor damageNTSB MIA02LA150Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Leesburg, FLLoss of engine power for undetermined reasons during takeoff, resulting in the airplane colliding with the ground and nosing over during the subsequent forced landing.Jul 28, 2002 · N1242V · DestroyedNTSB ATL02LA147Accident · No injuriesLimited investigationFinal reportAurandt Rotor Horse · Cape Coral, FLThe loss of engine power for undetermined reasons.Jul 28, 2002 · UNREG · Substantial damageNTSB MIA02LA136Accident · No injuriesLimited investigationFinal reportYakovlev Yak 52 · Parrish, FLThe in-flight failure of a carburetor/fuel line fitting, resulting in loss of engine power, a forced landing to unsuitable terrain, and a ground collision with a farm vehicle during the emergency landing.Jul 17, 2002 · N2183F · Substantial damageNTSB ATL02LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Clearwater, FLThe loss of engine power for undetermined reasons.Jun 28, 2002 · N2935Q · Substantial damageNTSB MIA02FA113Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Naples, FLThe pilot's failure to maintain airspeed above the stall speed while maneuvering to land after the engine ceased operating for undetermined reasons, which resulted in a stall/spin, an uncontrolled descent, and an impact with the ground.Jun 19, 2002 · N9127L · DestroyedNTSB ATL02LA108Accident · No injuriesLimited investigationFinal reportCessna T210N · Orlando, FLThe pilot's inadequate planning decision that resulted in fuel exhaustion and subsequent loss of engine power.May 28, 2002 · N4672Y · DestroyedNTSB ATL02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pahokee, FLThe loss of engine power and the post-landing fire for undetermined reasons.Apr 11, 2002 · N30660 · DestroyedNTSB MIA02LA078Accident · Serious injuriesLimited investigationFinal reportUltravia Aero Int' Pelican Club PL · Crystal River, FLThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot-in-command misjudging the proper glidepath resulting in the in-flight collision with a tree and subsequent uncontrolled in-flight collision with the ground.Apr 4, 2002 · N60980 · Substantial damageNTSB ATL02LA071Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Naples, FLThe loss of engine power for undetermined reasons.Mar 31, 2002 · N122SE · Substantial damageNTSB MIA02LA057Accident · Serious injuriesLimited investigationFinal reportCessna R172E · River Ranch, FLThe reported loss of engine power due to undetermined reasons. Contributing factors in the accident were an improper flap setting, excessive landing speed, and terrain consisting of berms.Feb 1, 2002 · N7878N · Substantial damage