Skip to content

NTSB investigations, GA

20 cases where the first occurrence was “Fire”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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 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" = 171) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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\" = 171)
  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.

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 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" = 171)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ATL07LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Woolsey, GAIn-flight fire of the right wing for undetermined reasons.Mar 29, 2007 · N1MQ · Substantial damage NTSB ATL07CA015Accident · No injuriesData collectionFinal reportCessna 172G · Dalton, GAThe pilot's improper starting procedures, which resulted in an on-ground engine fire.Nov 4, 2006 · N4368L · Destroyed NTSB ATL05IA025Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Peachtree City, GAThe failure of maintenance personnel to properly torque a fuel line fitting, which resulted in a fuel leak and in-flight engine fire.Nov 16, 2004 · N723CD · Minor damage NTSB ATL99LA103Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Woodstock, GAA loose connection between the fuel line fitting and the burner assembly which resulted in a fire.Jul 4, 1999 · N9808S · Destroyed NTSB MIA99LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Lawrenceville, GAA fire from an undetermined origin.Oct 23, 1998 · N5918E · Destroyed NTSB ATL94LA042Accident · No injuriesLimited investigationFinal reportCessna 182D · Donalsonville, GAThe pilot's failure to clear the induction systems of excessive fuel.Jan 22, 1994 · N8980X · Destroyed NTSB ATL93IA113Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Savannah, GALeakage of the number 7 fuel nozzle, which resulted in an in flight engine fire.Jun 18, 1993 · N467AA · Minor damage NTSB ATL91FA155Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Cartersville, GAThe mechanic's improper replacement of the fuel line b-nut, and the inadequate inspection of the repair work by the quality assurance inspector.Aug 7, 1991 · N9094Z · Substantial damage NTSB ATL91LA045Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAAn electrical short related to the alternator from an undetermined source.Jan 23, 1991 · N4718D · Substantial damage NTSB ATL90DKG05Accident · No injuriesFinal reportAyres Bull Thrush · Americus, GAFailure of the engine main oil line which allowed the engine oil to be ignited by the hot engine.Aug 4, 1990 · N4025Q · Destroyed NTSB ATL89FA166Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lithia Springs, GAInflight engine/wing fire due to a failure of the right engine's left exhaust tailpipe. The exhaust tailpipe failed in fatigue as a result of fluctuating stresses induced by a deteriorated engine mount in conjunction with unevenly distributed clamping loads…Jun 21, 1989 · N83AT · Destroyed NTSB ATL88LA006Accident · No injuriesLimited investigationFinal reportBeech H-18 · Sandersville, GAThe cockpit began to fill with smoke during initial climb after the plt raised the ldg gear. The plt returned to the arpt and made an emergency ldg. After evacuating the acft, the plt observed that the rt engine nacelle aft of the firewall was on fire.…Oct 8, 1987 · N711LC · Substantial damage NTSB ATL86LA044Accident · No injuriesLimited investigationFinal reportHughes 269B · Stone Mountain, GADuring ground refueling of the aircraft the fuel tank was over- filled and the fuel spilled over onto the ramp. The fuel was ignited and the aircraft was destroyed by fire.Dec 18, 1985 · N9303F · Destroyed NTSB ATL85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Reidsville, GAThe acft was found burning in the woods by the foresty service. No persons or baggage were found. The date, time & cause of the accident is unknown. Suspected drug related activity. According to FAA records, the acft was not officially registered. It had been…Feb 28, 1985 · N4565P · Destroyed NTSB ATL85IA047Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Atlanta, GADuring cruise flt electrical fire erupted in the circuit board and electrical components of the temp control unit for the rear galley oven. Associated circuit breaker opened, electrical power to galley was turned off and within minutes the unit was cool to…Dec 4, 1984 · N264US · Minor damage NTSB MIA84LA221Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Bainbridge, GAThe acft was destroyed by fire after it crashed into a wooded area just beyond the runway after taking off on a crop control flt. The plt stated that after takeoff he saw smoke and flames coming from under the cowling. The acft would not maintain alt and…Aug 7, 1984 · N9943P · Destroyed NTSB ATL83LA347Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Blackshear, GAThe pilot stated that during a spray run, a vibration was felt, the engine backfired and flames erupted from the right underside of the cowling. Power was lost continuously until over the landing strip at 50 feet AGL when all power was lost. The acft landed…Aug 31, 1983 · N1635S · Substantial damage NTSB ATL83IA054Incident · No injuriesIncident investigationFinal reportGulfstream American G-159 · Chamblee, GAOrion airlines flt 110 experienced an engine fire immediately after tkof from dekalb-peachtree airport. At 400 ft AGL, the rt engine fire warning lt illuminated. Flames were observed over the wing and coming from the inbd side of the right eng cowl. The rt…Dec 8, 1982 · N153TG · Minor damage NTSB ATL82IA103Incident · No injuriesIncident investigationFinal reportPiper PA-31P · Savannah, GADuring flight, electrical fumes, smoke and sparks began emitting from the circuit breaker panel immediately left of the pilot's seat. The pilot was forced to move to the right seat. He tried to suppress the sparks with a chemical fire extinguisher and tried…Apr 2, 1982 · N25MA · Minor damage NTSB ATL82FA052Accident · No injuriesField investigationFinal reportCessna 401 · Jessup, GAAfter reaching a cruise altitude of 9500 feet the pilot noticed smoke coming out of the left engine cowling. He then proceeded to reduce the left throttle but was unable to move the lever. According to the pilot the fire was extinguished when the left fuel…Feb 10, 1982 · N8299F · Substantial damage