NTSB investigations
450 cases where the first occurrence was “Fire”.
Cases, newest first
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 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."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 MKC90LA110Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Gardner, KSAn in-flight fire of undetermined origin.NTSB MIA90FA101Accident · 1 fatalField investigationFinal reportLockheed L-1049F · Levittown, PRFire of an undetermined origin that resulted in a loss of power in two engines during a three engine ferry flight. Factors related to the accident were: failure of the pilot to obtain the required authorization for the three engine ferry flight, and his…NTSB DEN90LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Delta, COA deteriorated fuel line.NTSB LAX90LA109Accident · 1 fatalLimited investigationFinal reportCameron O-105 · Phoenix, AZImproper modification of the balloon's fuel/heater system by the owner/operator and failure of the fuel line connection, which resulted in a fuel system leak and gondola (basket) fire.NTSB LAX90LA107Accident · No injuriesLimited investigationFinal reportBeech B-19 · Chiriaco Summit, CAA engine compartment fire of undetermined origin dduring engine start.NTSB CHI90IA064Incident · No injuriesIncident investigationFinal reportBoeing 747-151 · Detroit, MIA fire in the aft cargo compartment for undetermined reasons(s).NTSB LAX90FA061Accident · Minor injuriesField investigationFinal reportBoeing 737-204 · Tucson, AZFailure of the operator's maintenance personnel to detect an electrical wire which had chafed against a hydraulic line and which eventually arced causing a leak in the hydraulic line and subsequent fire and hydraulic system failure. In addition, previous wear…NTSB CHI90LA048Accident · No injuriesLimited investigationFinal reportCessna 310Q · Grand Rapids, MIThe undetermined engine compartment fire during the initial climbout. A factor was the failure of the pilot to shut off the fuel supply to the engine.NTSB CHI90FA029Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Monroe Center, ILIn-flight fire initiated by an inadequately installed wiring harness and propagated by an existing fuel leak which was not repaired.NTSB MKC90FA026Accident · Serious injuriesField investigationFinal reportCessna T210 · Columbia, MOAn engine compartment fire due to a missing turbocharger exhaust duct and tailpipe assembly. The clamp used to retain the tailpipe assembly to the turbocharger was also missing, contributing factor(s) was: the soft terrain.NTSB BFO90LA009Accident · No injuriesLimited investigationFinal reportBeech C33 · Richmond, VACracked fuel flow indicator fuel line which allowed fuel to come in contact with electrical components of the instrument panel which resulted in a fire.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.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.NTSB LAX89DVM05Accident · No injuriesFinal reportSkelton Emeraude · Watsonville, CAAn inadequate fuel line, due to improper installation by the owner/builder, fuel line failure, fuel line leak, and a subsequent fire.NTSB BFO89FA059Accident · 2 fatalField investigationFinal reportBeech E18S · Glen Burnie, MDA fire that erupted in the cockpit of the aircraft (under a side panel). Related factors were: smoke and fumes in the cockpit which reduced the pilot's visual perception and ability to see.NTSB MIA89LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Luquillo, PRFailure of the left exhaust stack which resulted in an engine fire, loss of engine power, and subsequent ditching of the acft in ocean waters.NTSB CHI89FA122Accident · No injuriesField investigationFinal reportPiper PA-60-700P · Griffith, INFailure of the turbocharger exhaust tailpipe assembly retaining clamp.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…NTSB SEA89LA109Accident · No injuriesLimited investigationFinal reportCessna 177B · Minden, NVThe inadequate maintenance which caused a crack in the fuel pressure line leading into the carburetor.NTSB ATL89MA123Accident · 3 fatalMajor investigationFinal reportBeech 200 · Pensacola, FLAn in flight cabin fire of undetermined origin, and smoke (toxic condition) in the crew compartment, which resulted in physical impairment of the flight crew.NTSB MKC89LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Marshall, MNThe failure of an unapproved weld between the exhaust system and muffler. The failed weld resulted in the muffler separating and an in-flight fire.NTSB FTW89LA077Accident · No injuriesLimited investigationFinal reportGulfstream 680FLP · Lohn, TXArson undertaken to conceal illegal activity.NTSB DCA89MA034Accident · No injuriesMajor investigationFinal reportBoeing 737-300 · Oakland, CAIgnition of puddled fuel from a blocked combustor drain line, and a slow start during which fuel was misted and blown out the tail pipe. An existing tailwind at the gate allowed the fuel to wet the tail surfaces and be ignited during the APU start. The…NTSB MKC89LA075Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARAn engine fire during engine start for undetermined reasons.NTSB MKC89LA066Accident · No injuriesLimited investigationFinal reportCessna 182RG · Ft. Madison, IAAn electrical wiring short that caused an in flight fire.NTSB ATL89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Huntersville, NCFire resulting from an oil leak of undetermined origin in the area of the left engine.NTSB ANC89LA014Accident · No injuriesLimited investigationFinal reportCessna TU206A · Soldotna, AKThe ATP certificated pilot and his two passengers were returning from a hunting trip when the turbocharged Cessna 206 caught fire soon after landing. The pilot stated that the engine quit during the landing roll and an attempt at restarting the engine as the…NTSB FTW89FA006Accident · 1 fatalField investigationFinal reportMooney M20E · Longview, TXThe airplane was in cruise flight when the pilot transmitted that he had smoke in the cockpit. 53 seconds later contact was lost. The nose and left wing were slightly down when the acft struck trees and terrain at high speed. Fire started several minutes…NTSB DEN89LA018Accident · No injuriesLimited investigationFinal reportCessna U206 · Brush, COFollowing landing at an unattended airport, while back-taxiing, the eng failed. During restart the plt heard a loud 'pop' from the eng compartment followed by white smoke and flame. The plt and pax exited the acft and the plt went to a nearby phone to call…NTSB LAX88DVA12Accident · No injuriesFinal reportAyres S2R · Kerman, CADrg an aerial application flt, the eng lost power & a fire started in the eng compartment when a fuel line failed, just forward of the fire wall. The plt made a successful landing in an open field, but the acft was substantially damaged due to the fire.NTSB DEN88LA127Accident · No injuriesLimited investigationFinal reportCessna 182K · Cotton City, NMThe pilot reported that he was attempting to start the Cessna 182 for a cross country, solo, personal transportation flight. During the starting procedures, the engine backfired and the pilot smelled and saw smoke coming from the engine cowling area. The…NTSB NYC88LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · W. Peru, METhe cockpit of the Piper PA-28 filled with smoke after takeoff, at an altitude of approximately 800 ft. the pilot tried to land on a road and struck trees, shearing off the wings. The fuselage landed on a road, inverted and was immediately enfulfed in flames.…NTSB ATL88FA158Accident · No injuriesField investigationFinal reportBeech E18S · Cynthiana, KYThe plt was repositioning the airplane from an on-demand air taxi freight flight. He was en route from rochester, NY to huntsville, al with a planned refuel stop at louisville, KY. Near falmouth, KY he changed his destination to lexington 'due to a developing…NTSB LAX88LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Hayfork, CAAfter landing and taxiing to parking, the pilot heard a noise, the pilot exited the airplane and noticed a fire in the engine compartment area. The airplane was consumed by fire shortly thereafter.NTSB MIA88LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hialeah, FLEngine stalled during landing roll. During attempts to restart engine pilot flooded it. The engine backfired and the excess fuel in the carburetor caught fire. The pilot did not motor the engine in time to draw the flames into the engine and the fire spread…NTSB ATL88IA147Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Cleveland, OHNTSB MIA88DL001Accident · Serious injuriesFinal reportFalcon Special S/R · Lakeland, FLThe pilot experienced an in flight fire in the exhaust system while performing acrobatic maneuvers at an airshow. The aircraft is equipped with a pump that injects oil into the exhaust system to produce a visible smoke trail when vaporized by the exhaust…NTSB DCA88IA044Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Boston, MAThe improper installation of the battery ground connection that resulted in premature loosening of the connection and electrical arc ignition of pooled fuel in the cac bilge. The fuel was not drained overboard due to inoperative cac bilge area drain valves.…NTSB FTW88LA054Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Borger, TXShortly after takeoff there was smoke in the cabin. The plt started a turn back toward the runway. When he turned off the electrical master switch the engine stopped producing power. Attempts to restart the engine were not successful. He impacted a heavy…NTSB FTW88IA052Incident · No injuriesIncident investigationFinal reportDassault-Breguet DA-10 · Dallas, TXThe flight experienced in-flight fire resulting from an electrical short in an auxiliary circuit breaker panel installed after aircraft manufacture. The short resulted from the use of a mounting bracket that chafed against the input wires. The flightcrew…NTSB CHI88IA045Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Waterloo, IANTSB NYC88LA058Accident · No injuriesLimited investigationFinal reportCessna 182 · Hammonton, NJThe aircraft had taxied to the runup area and during this process of engine runup, the pilot stated that the engine was running rough on one magneto but smooth on the other. The carburetor mixture was leaned but the engine quit. When an attempt to restart was…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…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…NTSB NYC88FA051Accident · 1 fatalField investigationFinal reportCessna 310R · Hector, NYThe pilot made a routine IFR position report 12 minutes prior to the accident. Witnesses observed an 'orange ball' before the crash. Evidence at the crash site showed inflight jettison of the pilot's emergency window, positive aerodydnamic overload separation…NTSB MIA88LA037Accident · No injuriesLimited investigationFinal reportMandley Steen Skybolt · Placida, FLWhen attempting to start the eng the plt heard it backfire & then observed smoke coming from under the eng cowling. He then immediately exited the acft & left the scene to summon the fire department. He later returned to find the aircraft consumed by fire.…NTSB MIA88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ft. Myers, FLAccording to a witness the acft was taxiing slowly but at a higher than normal RPM. When the acft was stopped in the runup area, the right main landing gear caught on fire burning the bottoms of both wings. Examination of the brakes revealed that the linings…NTSB FTW88FA007Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Houston, TXThe acft developed a fire in the eng area during the initial climb after takeoff. When the eng lost power the plt attempted a lndg in a small park. The acft touched down just short of a drainage ditch and collided with the sloping embankment on the opposite…NTSB MIA88IA011Incident · No injuriesIncident investigationFinal reportCASA C-212-200 · Mayaguez, PRThe commuter flt was taxiing to the gate, when the plt observed a fire warning light for the no 2 eng. The fire bottle was discharged & the fire was extinguished. An exam revealed that a fuel line, p/n 3103385-1, had broken and had started a fire. An exam of…NTSB MKC88FA005Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Lincoln, NEDuring climbout, smoke began filling the cabin and shortly thereafter the eng stopped. Ground witnesses observed smoke coming from the eng compartment just before the acft impacted a large woodpile behind a house located 1/2 mile east of the arpt. Examination…