NTSB investigations, AL

10 cases where the first occurrence was “Fire”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations, AL per year, 1982–2026: 10 cases
1982	2
1984	1
1986	1
1994	1
1995	2
2000	1
2006	1
2007	1

Where

Open the map

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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ATL07LA034Accident · No injuriesLimited investigationFinal reportGreenhaw, William Lancair 360 · Guntersville, ALFailure of an unapproved automotive fuel line installed by the owner/pilot mechanic which resulted in an engine fire during taxi after landing.Jan 23, 2007 · N117BG · Substantial damage NTSB DEN06CA124Accident · No injuriesData collectionFinal reportBell 47G-2 · Hayden, ALengine fire for reasons undetermined.Sep 9, 2006 · N23947 · Destroyed NTSB ATL01IA001Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Birmingham, ALThe failure of maintenace personnel to follow fleet campaign directive on how to install a certificate holder.Oct 1, 2000 · N69826 · Minor damage NTSB ATL95LA091Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Huntsville, ALA loose wire which shorted between an exposed terminal on the avionics bus relay and the oil line to the oil pressure gage, and the failure of maintenance personnel to tie up loose wires.Apr 26, 1995 · N67HC · Substantial damage NTSB ATL95LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Foley, ALAn engine fire for undetermined reasons.Jan 3, 1995 · N6829F · Destroyed NTSB ATL95FA007Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Newville, ALFailure of maintenance personnel to properly install the marmon clamp on the discharge side of the turbocharger.Oct 23, 1994 · N999BW · Destroyed NTSB ATL86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300T · Fort Deposit, ALShortly after takeoff smoke and flames entered the cockpit. The pilot returned to the airport and landed hard damaging the firewall. Examination of the aircraft revealed that the turbo charger exhaust clamp broke and allowed hot exhaust gases to ignite a fire…Apr 7, 1986 · N22370 · Substantial damage NTSB ATL85LA023Accident · Minor injuriesLimited investigationFinal reportFour Seasons Aviations American Aerolight · Springville, ALAt aprx 150 ft the plt heard a noise and observed a fire involving the rear portion of the acft. The plastic fuel tank ruptured and burning fuel was sucked aft through the pusher prop. The ballistic parachute was deployed and opened as the acft hit a 60 ft…Oct 27, 1984 · N953AA · Substantial damage NTSB ATL82FKJ14Accident · Serious injuriesFinal reportGrumman G-164 · Bay Minnette, ALThe pilot reported that during takeoff, he noticed extreme heat in the cockpit and the engine began to surge, then lose power. He landed on the remainder of the runway and stopped after running off the end. However, the engine was on fire and the plane was…Sep 27, 1982 · N463RF · Destroyed NTSB ATL82DA223Accident · No injuriesFinal reportAero Commander 680FL · Alabaster, ALPrior to the post-maintenance inspection flight the pilot/owner, who is a certificated A&P mechancic, had been calibrating the fuel flow on the right eng fuel injector pump. An external line had been connected to the fuel flow transmitter fitting of the fuel…Aug 2, 1982 · N11GT · Destroyed