NTSB investigations, 2002, GA

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

Cases per year

19822026
NTSB investigations, 2002, GA per year, 1982–2026: 121 cases
19823
19836
19846
19854
19866
19873
19883
19903
19912
19923
19932
19946
19953
19967
19978
19984
19994
20003
200110
20027
20038
20046
20053
20066
20075

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\" = 'GA' 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 MIA03LA023Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Gainesville, GAa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.Dec 3, 2002 · N8578M · Substantial damageNTSB ATL03LA007Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Highfalls, GAThe pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…Oct 19, 2002 · N4002G · Substantial damageNTSB MIA02LA135Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cochran, GAA loss of power while conducting aerial application to cotton crops due to failure of a magneto housing, and the resultant emergency descent and landing to an unsuitable field, causing the collision with a tree.Jul 17, 2002 · N8943Q · Substantial damageNTSB MIA02LA110Accident · 1 fatalLimited investigationFinal reportHarrison Pietenpol Air Camper · Bainbridge, GAa loss of power due to the passenger's inadvertent deactivation and restricting the movement of the throttle, which resulted in a forced landing and subsequent impact with trees.Jun 13, 2002 · N7224X · DestroyedNTSB ATL02LA110Accident · Serious injuriesLimited investigationFinal reportKendall, Blair Rans S-12 · Lincolnton, GAThe loss of engine power due to the delamination of the propeller blade during takeoff, and the pilot's improper touchdown flare during the emergency landing resulted in a hard landing.May 25, 2002 · N257BK · Substantial damageNTSB ATL02FA072Accident · 2 fatalField investigationFinal reportNorth American T-6-AT6D · Gainesville, GAA loss of engine power following a supercharger bearing failure and subsequent collision with the ground while maneuvering for an emergency landing.Apr 1, 2002 · N7471C · Substantial damageNTSB ATL02FA057Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hamilton, GAThe loss of engine power for undetermined reasons.Feb 28, 2002 · N33584 · Substantial damage