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 FTW86IA020Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Dallas/Ft.Worth, TXNo. 3 eng developed an exhaust stack fire during the second attempted start following taxi out. The 1st start was aborted when crew became aware of a 15 minute delay before takeoff. During the 2nd start, excess fuel torched in the combustors and the exhaust…NTSB LAX86LA020Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Palo Alto, CAThe plt said that after landing and turning onto the parallel taxiway, the engine quit. During an attempted re-start, fire was noticed coming from the engine compartment. The plt and his passenger evacuated the acft, and arpt personnel put out the fire. The…NTSB SEA85LA230Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Burlington, WADuring initial climb, the plt smelled smoke & heard a backfire, then the eng lost power. A forced landing was made in a field on rough/uneven terrain. During the landing roll, the acft struck a ditch & was damaged. A visual inspection revealed that the left…NTSB CHI85LA374Accident · No injuriesLimited investigationFinal reportCessna T210N · Minocqua, WIThe PIC attempted to start the engine. The engine started but in about 3 seconds stopped. During a second start attempt a fire started in the engine compartment. The PIC thought he had extinguished the fire when flames were seen in the copilot pedal area. The…NTSB FTW85FQG02Accident · No injuriesFinal reportPiper PA-28-140 · Big Spring, TXThe acft cockpit/cabin filled with smoke after takeoff. The plt & passg smelled an odor of electrical wiring burning and saw fire at the firewall near the rudder pedals. The acft was turned 180 degrees and landed on rwy 35. The 2 occupants immediately…NTSB BFO85IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Richmond, VAThe flt was in cruise at FL 350 when the cabin crew reported a cabin fire in the vicinity of seat 28A. Shortly after, a lower aft body overheat warning was recvd. The flt diverted to Richmond, VA. During descent, the flt crew performed the appropriate…NTSB DEN85LA210Accident · No injuriesLimited investigationFinal reportHughes 369D · Cheyenne, WYThe flt was a pipeline patrol operation. While in flt, smoke was observed in the cabin. The plt made an unsuccessful autorotation resulting in substantial damage to the helicopter. Investigation revealed the smoke was from an inflight eng compartment fire.…NTSB ATL85LA227Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Camden, SCWhile the acft was flying over wooded terrain, the eng lost power. The plt saw a plowed field aprx 3 mi away & began an emerg apch to the field. The acft struck the tops of trees on final apch, but continued flying until the plt made a gear up landing. An…NTSB NYC85LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Lawrence, MAAfter refueling the acft, the plt attempted to start the eng with the throttle full open and the mixture at idle cut off. The instructor thought the eng was vapor locked and was going to drain the gascolator when he noticed a fire in the carburetor airbox.…NTSB LAX85LA320Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Durham, CADuring an ag flight in which a compound containing sulfur dust was being sprayed a fire began in the acft's spray apparatus. The cockpit filled with heavy smoke & the plt made a successful forced ldg in the underlying field. The fire spread & eventually…NTSB FTW85LA289Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19-3 · Gatesville, TXThe acft was destroyed by fire after executing an emergency landing following an inflight fire and eng failure. Shortly after takeoff the plt smelled electrical insulation overheating and noticed a decrease in fuel pressure. Fire broke out on the left side of…NTSB LAX85LA296Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Ajo, AZWhile attempting to start the engine for a planned air taxi flight under conditions including an outside air temp of 118 degs f, a fire erupted in the engine compartment. The occupants safety evacuated the acft & had to walk 1/4 of a mile to obtain…NTSB ANC85LA108Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Talkeetna, AKWhile in flt, the plt smelled smoke. Within 30 sec, smoke was observed coming from around the firewall & under the floorboards. The acft was over an airstrip, so the plt made a 360 deg turn & landed there. The plt said that he immediately applied brakes when…NTSB MIA85LA198Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The plt reported that during an overwater flt, a fire began in the front section of the acft while he was cruising at 10,500 ft. he radioed his position on the emergency freq (121.5 mhz) & squawked an emergency code (7700) on his transponder. Subsequently, he…NTSB SEA85LYE02Accident · No injuriesFinal reportAero Commander 600S-20 · Pasco, WAThis Aero Commander 600S-20 departed on an aerial application flight. Shortly after takeoff the pilot noticed flames coming from the engine compartment, experienced a power loss and made a forced landing in sand dunes, substantially damaging the aircraft.…NTSB FTW85LA242Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · El Paso, TXShortly after liftoff, the plt first smelled, then observed smoke coming into the cockpit from under the instrument panel. Shortly thereafter, the eng quit completely. The plt made a forced landing in an open area off the rwy. During the landing roll, the…NTSB DEN85LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bluff, UTThe acft was destroyed by fire which began during an engine start. The plt stated that he used porper hot engine start procedures. He said the throttle was not pumped. The plt observed that the fuel pressure went to zero during the second start attempt. Smoke…NTSB FTW85LA235Accident · No injuriesLimited investigationFinal reportGrumman G-164A-450 · Basile, LAThe plt detected a fuel leak after takeoff and returned to land. He shut the acft eng down and exited the acft, but the acft busrt into flames before the prop stopped turing. Subsequent investigation discovered a material failure in a fuel line on the eng…NTSB LAX85FA238Accident · No injuriesField investigationFinal reportBeech V35A · Santa Monica, CAAfter deptg & climbing to 4500', the plt & his plt rated pax noted a fuel odor & returned to the arpt to land. Bfr lndg,the plt called the tower (twr), but didn't advise twr psnl of the fuel odor or of a psbl prblm. As the acft was turning off the rwy, fire &…NTSB CHI85FA170Accident · No injuriesField investigationFinal reportBeech E18S · Janesville, WIOn April 20,1985 at approx. 2100HRS local time a Beechcraft model E185 N68Y owned and operated by blackhawk airways inc. was conducting a normal runup in preparation for a flight from Janesville, WI. (Jvl) to chicago IL. (Ord). At the completion of the of the…NTSB BFO85LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA 22-150 · New London, VAWhile exiting the traffic pattern after tkof the plt smelled smoke and observed flames near the left rudder pedal. After failing to put the fire out with his shoes the plt returned to the arpt and subsequently lndd using side window to look out of due to…NTSB FTW85LA156Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Justin, TXThe purpose of the flt was a mult-engine flt check given by a designated examiner to the commercial plt. According to the examiner the right eng, which was still hot from the previous flt, would not start on the first attempt. After a successful start of the…NTSB MIA85LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pahokee, FLThe plt stated that when he smelled smoke in the cabin, he landed & taxied to the ramp area, then a fire erupted. An investigation revealed the fire started where an electrical short occurred near the APU plug (in the area of the aft baggage compartment).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…NTSB DEN85LA093Accident · No injuriesLimited investigationFinal reportCessna 421C · Butte, MTWhile in level flt the plt noticed a puff of smoke emit from the left engine, followed by the appearance of hydraulic fluid and the illumination of the left and right hydraulic flow lights. The plt lowered the landing gear during the apch, however, the nose…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…NTSB ATL85LA087Accident · No injuriesLimited investigationFinal reportBeech B-80 · Newbern, NCPilot experienced left engine fire at cruise. Emergency procedures completed, extinguishing the fire. Left nacelle sustained substantial damage, preventing determination of fire orgin.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…NTSB SEA85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Aurora, ORThe acft caught fire during start. The FAA inspectors said that AD 72-11-01 had not been followed in compliance.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…NTSB CHI85LA001Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greenbush, MNFollowing an uneventful approach and landing, the plt was taxiing back up the runway when the right engine quit. The right seat passenger immediately noted flames coming from the engine and notified the plt, who swung the acft into positon for wind to keep…NTSB ANC84FA190Accident · Serious injuriesField investigationFinal reportBellanca 8KCAB · Ouzinkie, AKPlt completed 5 turn spin, cockpit began filling with smoke. Electrical equipment was turned off and plt was descending for precautionary landing when elevator control was lost. Acft settled into 75 ft tall trees. Source of fire which resulted in battery…NTSB FTW84LA378Accident · Minor injuriesLimited investigationFinal reportBell 206B · Houma, LAThe helicopter was on a cargo, non scheduled air taxi flight when the plt smelled smoke. A precautionary landing was made on a beach after which the acft was destroyed by fire.NTSB NYC84FNE05Accident · Serious injuriesFinal reportMooney M20C · Danbury, CTAn eng compartment fire occurred shortly after takeoff & smoke entered the cockpit. The plt then made a forced landing in a sand pit aprx 1 mi fm the arpt. He & the pax exited the acft with serious burns. An inv revealed an exhaust pipe had failed at a…NTSB ANC84LA133Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Skwentna, AKDuring cruise, plt was troubleshooting rhythmic power interruption (missing) when fire broke out in the engine compartment. Plt headed for arpt, gear down, but elected to make a precautionary landing off arpt when the fire intensified. Landing gear sheared in…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…NTSB ATL84LA238Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Hartsfield, SCThe plt said he smelled an electrical fire while spraying. He elected to land but before he could the engine quit. A forced landing was made in a cornfield. The acft burned. The fire origin was not located in the totally burned wreckage.NTSB DEN84LA238Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Selz, NDThe plt smelled and saw smoke from the engine which began to lose power. An emergency landing was made on a narrow dirt road. After stopping the plt egressed and ran. He said that about 2 minutes later the fuel tanks blew. Post accident examination indicated…NTSB FTW84LA295Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-301T · San Angelo, TXThe plt stated that he was in a climb to cruise when he smelled smoke. He immediately turned back towards the arpt but the cabin filled with smoke so he elected to make an emergency landing in a plowed field. After landing the acft was totally destroyed by…NTSB FTW84LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tallulah, LAThe acft caught fire shortly after takeoff and the plt landed in a wheat field. The nosewheel dug into the soft field and the acft nosed over. This acft has been the subject of recommendations on worn and deteriorated fuel lines. The pltsdescription of his…NTSB CHI84IA196Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-40 · Minneapolis, MNDuring climb from FL330 to FL370 the 1st officer saw sparks and smoke coming from the left side panel under his glare shield. Cockpit lights were turned off and smoke stopped. Flt returned to Minneapolis and landed without incident. Inspection of the acft…NTSB LAX84FA283Accident · No injuriesField investigationFinal reportPiper PA-22 · West Covina, CAWhile returning to the arpt & towing a banner, smoke entered the cockpit & a small fire began buring, forward of the left/lower part of the firewall. The plt turned the acft to land in a field. He opened the right cabing door, all air vents & the window on…NTSB LAX84LA293Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Concord, CAWhile the plt was waiting for a takeoff clearance, tower personnel notified him that the acft appeared to be on fire. The plt shut down the eng & exited the acft. The fire developed, but was mainly confined to the eng compartment. It was promptly extinguished…NTSB MIA84FA078Accident · Serious injuriesField investigationFinal reportHiller UH-12E · Waldo, FLThe acft was being used to dispense aerial incendiary devices (aids) to control forest burning. The aids were 1.25 inch diameter polystyrene balls containing potassium permanganate. They were injected with ethylene glycol prior to being dropped out of the…NTSB MKC84FA069Accident · Minor injuriesField investigationFinal reportBellanca 17-30 · Kansas City, KSThe acft caught fire shortly after takeoff, the plt declared an emergency and the acft was cleared to 'take any runway or any taxiway.' The plt landed in an open field on the airport. The acft was destroyed by fire. Investigation revealed that the main source…NTSB ATL84LA091Accident · No injuriesLimited investigationFinal reportCessna 404 · Covington, KYA fire ignited in the right engine on the landing roll. The fire source was near the point where the fuel supply line connects to the engine driven fuel pump. The acft was on its first revenue flight after the right engine was changed, atwhich time the…NTSB LAX84IA147Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Redding, CAWhile taxiing to takeoff, smoke was noted in the cockpit area, shortly after the plt activated the heater ignition switch. The plt immediately stopped & secured the acft & assisted the passengers in deplaning. An exam of the janitrol heater, model B4050,…NTSB SEA84FA031Accident · No injuriesField investigationFinal reportPiper 601P · Garfield, WAThe acft was forced to land on a road due to a fire in the left wing. During the investigation of the accident it was found that the left turbocharger had been removed and reinstalled several times. A clamp on the turbocharger exhaust wasimproperly installed…NTSB LAX84LA093Accident · No injuriesLimited investigationFinal reportBeech C24R · Monterey, CAFire erupted in the eng compartment during the eng run-up. Investigaiton revealed that 7 of the 8 nuts securing the exhaust manifold to the cylinders were missing. The only nut present was loose but retained the #1 cyl exhaust tube. The #2 cyl exhaust tube,…NTSB NYC84LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Milford, CTThe pilot reported that as he was starting the engine, fire broke out. He attempted to put out the fire with on-board extinguishers, but failed. The acft was destroyed by fire.