Skip to content

NTSB investigations, OK

10 cases where the first occurrence was “Fire”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 FTW01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Washington, OKthe in-flight fire for an undetermined reason, which resulted in a forced landing. A contributory factor was the lack of suitable terrain for the forced landing.May 3, 2001 · N9696B · Substantial damage NTSB FTW01FA015Accident · 2 fatalField investigationFinal reportBeech BE-76 · Tulsa, OKthe instructor pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around, which resulted in his loss of control of the airplane. Contributory factors were the engine fire, the pilot's failure to follow the…Oct 31, 2000 · N23823 · Destroyed NTSB FTW00LA251Accident · No injuriesLimited investigationFinal reportBeech BE58 · Bethany, OKthe fire, which ignited in the engine compartment for undetermined reasons while taxiing.Sep 6, 2000 · N84DE · Substantial damage NTSB FTW98LA182Accident · No injuriesLimited investigationFinal reportFroberg Rotorway Executive · Sand Springs, OKThe failure of the owner/pilot to complete maintenance on the helicopter.Apr 13, 1998 · N71RF · Destroyed NTSB FTW96FA183Accident · 4 fatalField investigationFinal reportPiper PA-28-151 · Vera, OKimproper installation by unknown person(s) of incorrect exhaust system clamps, which led to an exhaust system disconnect and a subsequent engine compartment fire.Apr 27, 1996 · N7845C · Destroyed NTSB FTW94IA198Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Caddo, OKThe fuel nozzle drain leak due to a defective o-ring.Jun 17, 1994 · N632AS · Minor damage NTSB FTW87FA142Accident · Serious injuriesField investigationFinal reportBeech 35 · Cookson, OKJust after takeoff smoke was smelled and then observed in the cockpit. The pilot beleived that the smoke source was electrical and turned off the master switch. Just before touchdown flames began burning the pilots left leg. The aircraft was stopped on the…Jun 13, 1987 · N3063V · Destroyed NTSB FTW86IA103Incident · No injuriesIncident investigationFinal reportPiper PA-31 · Kingston, OKAcft received minor damage as a result of an electrical fire in-flight while in cruise at 9,000' MSL. The plt stated that he observed smoke emanating from the c.b. panel mounted on the left side wall of the cockpit and that several c.b.'s popped and he lost…Jun 10, 1986 · N68ST · Minor damage NTSB FTW86FA076Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Anadarko, OKThe pilot radioed that he had smoke in the cockpit. He immediately made an emergency landng, down wind, in a farmer's field. Witnesses saw the aircraft's right wing drop before the plane touched down. The resulting impact tore the wings and engine off,…May 4, 1986 · N43775 · Destroyed NTSB FTW85FA137Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Foss, OKInflt fire at rear of lft eng caused by fitting of inlet fuel line to eng driven fuel pump being more than 1 & 1/2 turns from finger tight plt was A&P mech and did maint on a/c and had helped install lft eng 19.8 hrs prior to accident . Lft wing separated…Mar 5, 1985 · N6310U · Destroyed