Skip to content

NTSB investigations, AR

11 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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 FTW95LA154Accident · No injuriesLimited investigationFinal reportBeech G18S · Springdale, AREngine compartment fire due to undetermined reasons.Apr 2, 1995 · N512E · Substantial damage NTSB FTW95LA012Accident · No injuriesLimited investigationFinal reportCessna 172H · Moro, AREngine compartment fire due to undetermined reasons.Oct 9, 1994 · N8181L · Destroyed NTSB FTW91DPG14Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARPartial failure of the hopper, chemical fire, and the failure of the landing gear. A factor ws the loss of visual outside reference.Jul 15, 1991 · N6615 · Destroyed NTSB MKC90FA020Accident · 1 fatalField investigationFinal reportCessna 402B · Little Rock, ARA leak in the aircraft's fuel system which resulted in an in-flight fire. The origin of the fuel leak was not determined.Oct 29, 1989 · N6382X · Substantial damage NTSB MKC89LA187Accident · No injuriesLimited investigationFinal reportBeech V35B · Concord, ARImproper installation of the alternator wiring harness by the pilot/owner which resulted in chafed wiring and a subsequent electrical fire. The uneven terrain was a contributing factor.Aug 18, 1989 · N699T · Substantial damage NTSB MKC89LA075Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARAn engine fire during engine start for undetermined reasons.Mar 10, 1989 · N6602Q · Destroyed NTSB MKC88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osceola, ARThe airplane was being jump-started from an automobile. The flight instructor left for some equipment when the student called him back and said there was smoke in the cabin. The airplane started to burn and was demolished. The student stated there was a…Dec 16, 1987 · N1595J · Destroyed NTSB MKC88IA025Incident · Minor injuriesIncident investigationFinal reportBell 206L-3 · Little Rock, ARAn EMS helo was consumed in a fire while parked at a hospital heliport. The helo had recently returned fm a medevac flt and the on-board patient oxygen pressure was low. Two respiratory therapists participated in refilling the system after the flt. The system…Dec 10, 1987 · N86CH · Destroyed NTSB MKC87LA133Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mcdougal, ARThe ag airplane was on takeoff roll when the pilot smelled smoke in the cockpit. He stopped the airplane and turned off the fuel and switches before evacuating the airplane. He said the flames were coming from the cowling around the engine. Due to the total…Jul 9, 1987 · N6609Q · Destroyed NTSB DCA83AA037Accident · No injuriesFinal reportSwearingen SA226TC · Hot Springs, ARTurning onto the rwy the coplt observed a flash behind his inst panel. He then received an elect shock to his right arm from the right console. A fire then erupted at the lower right hand corner of his inst panel. The crew & pax evacuated the acft. The…Aug 28, 1983 · N503SS · Substantial damage NTSB FTW82DA135Accident · No injuriesFinal reportBeech S-35 · Jonesboro, ARThe pilot had completed his run-up in preparation for takeoff when he noticed smoke coming from behind the instrument panel and he exited the aircraft. The instrument panel was destroyed by fire before fire fighting equipment could extinguish the fire. No…Apr 18, 1982 · N7907K · Destroyed