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 ATL88LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sebring, OHWhile on final appch to land, a fire broke out in the airplane engine compartment. The commercial plt and his instructor evacuated the airplane after ldg and the airplane was destroyed by the fire. The acft was subsequently examined by an IA mechanic who…NTSB ATL88LA006Accident · No injuriesLimited investigationFinal reportBeech H-18 · Sandersville, GAThe cockpit began to fill with smoke during initial climb after the plt raised the ldg gear. The plt returned to the arpt and made an emergency ldg. After evacuating the acft, the plt observed that the rt engine nacelle aft of the firewall was on fire.…NTSB DEN88LA004Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Rio Rancho, NMThe plt rptd that she had vented the Balloon to land. She said it takes both of her hands to open the vent and hold it open. 'When the Balloon hit the ground the burner went on by itself, wide open. The envelope was swinging from the contact of the basket…NTSB MKC87LA183Accident · No injuriesLimited investigationFinal reportCessna 401 · Ames, IAThe unsked pax flt was climbing to cruise altitude having just deptd Ames, IA, when the PIC noticed a fire in the left eng. The PIC aborted the climb and returned to Ames. The left eng was secured before lndg which was uneventful. A post-fire insp of the eng…NTSB CHI87LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Indianapolis, INThe acft was on the third tkof of the day when the eng stopped on initial climb at the pilots estimated alt of 500 ft. he did a 180 turn back to the arpt but touched down short and ran through the perimeter fence. Examination of the acft revealed that the…NTSB LAX87FA306Accident · No injuriesField investigationFinal reportCessna 421C · Clifton, AZThe flt deptd ry 25 at greenlee cty arpt, Clifton, AZ on a VFR flt to phoenix, AZ. The plt & gnd witnesses rptd that shortly after lift-off, grayish/white smoke emanated from the left engine. The plt was unable to feather the prop, circled the arpt abt 2…NTSB FTW87FA197Accident · No injuriesField investigationFinal reportPiper PA-32R · Mexia, TXThe plt noticed smoke in the cockpit & started to make a precautionary lndg at Mexia, TX, which was nearby. However, drg the dscnt to lnd, the smoke dissipated, so he elected to cont to the destn. Drg the climb back to alt, smoke reappeared & was followed by…NTSB MKC87LA154Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Oelwein, IADuring a personal night x-c flt, the plt noticed a glowing condition in the engine compartment and also a loss of manifold pressure. The plt shut the fuel off, pulled the mixture to cutoff, and declared an emergency. The acft made an emergency landing in a…NTSB MIA87FA205Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Palatka, FLWitnesses stated that they heard the acft's eng sounding rough just before it crashed into the trees. Another witness stated that he noticed that there were flames & smoke coming from the left side of the plane. A tail pipe assembly was found on the ramp at…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…NTSB SEA87IA127Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BAE-146-100 · Las Vegas, NVDuring pushback and while starting the #4 engine the auxiliary power unit which provides electrical power to the engine starter tripped off the line. The loss of electrical power to the engine starter resulted in a hung start at approximately 25% N2 RPM.…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…NTSB NYC87FA146Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Sayre, PADrg initial climb after takeoff, smoke was observed in the cockpit. When the smoke became hvy, the plt decided to land. He attempted a forced landing on rising terrain in foggy conds. Subsequently, the acft crashed into the side of the hill & began burning.…NTSB FTW87FA116Accident · No injuriesField investigationFinal reportBeech V35-B · Terrell, TXWhile attempting to start the aircraft the starter solenoid wiring caught fire. The heat from the fire caused an overstressed brake line to fall, allowing brake fluid to drain onto the lip of the nose gear door. The fire then burned through the floor of the…NTSB LAX87DUM02Accident · No injuriesFinal reportRockwell S2R · Imperial, CADuring an aerial application applying sulphur, the sulphur ignited inflight. The pilot turned the aircraft back toward the airport; however, the cockpit filled with smoke and the pilot decided to land on a road. Due to the extent of fire damage it could not…NTSB LAX87LA192Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Novato, CAThe plt aborted the takeoff attempt before becoming airborne at a point near midfield on the 3360 ft rwy. He rptd smoke in the cockpit from an electrical short of unrptd origin. Both the plt and the plt-rated pax thought they would be able to stop on the…NTSB ATL87LA120Accident · No injuriesLimited investigationFinal reportCessna R182 · Owensboro, KYPlt in cruise flt at 5500 ft about 30 min after dep fm paducah when he noted a small amount of black smoke coming from top of panel. The rear seat pax noted flames in the panel at the same time. The plt noted his position in relation to Owensboro and…NTSB LAX87LA158Accident · No injuriesLimited investigationFinal reportThorp T-18 · Riverside, CAWhile on a flt to practice aerobatics, the plt was flying at 3500' when he felt a cold liquid on his rgt leg & noted the odor of fuel in the cockpit. Moments later, flames erupted in the cockpit. The plt bailed out & the airplane crashed on the southeast…NTSB ATL87MA057Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Pollockville, NCThe emerg med svc (ems/med-evac) helicopter (hel) was on a ngt flt with a 3 month old patient aboard. After rprtg lvl AT3000', the plt transmitted he was going to make an emerg lndg. This was flwd by svrl unreadable transmissions which apchctl psnl thought…NTSB SEA87LA041Accident · No injuriesLimited investigationFinal reportDouglas C-54/DC-4 · Pacific Ocean, WAThe plt reptd that he ditched his DC-4 in the Pacific Ocean on the evening of December 23 after experiencing an uncontrollable no. 3 eng fire at the conclusion of a tng flt. The ditching occurred in dark night conditions with minimal 10 foot swells having a…NTSB SEA87LA024Accident · No injuriesLimited investigationFinal reportCessna 182B · Bellingham, WADrg an attempted start, the eng backfired & an induction fire started. However, the plt did not continue cranking the eng. Strong surface winds inhibited the effectiveness of the acft's portable fire extinguisher. The plt then attempted to use an extinguisher…NTSB LAX87DUG01Accident · No injuriesFinal reportAero Commander 520 · Lucerne Valley, CADuring a pleasure flt, the plt reported that the right engine caught on fire. The plt made a landing on dry lake bed and disembarked from the plane examination of the wreckage revealed that the path of the landing roll showed no signs of melted metal or…NTSB LAX87IA029Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200 · Santa Ana, CAJust after takeoff the aircraft experienced a fire in the number 3 engine which was extinguished by the on board fire bottles. Investigation revealed that a secondary fuel line had pulled out of a b-nut ferrule fitting at the fuel flow divider manifold which…NTSB MKC87LA011Accident · No injuriesLimited investigationFinal reportGrumman G164B · Memphis, MOThe aerial application acft was en route to seed a wheat field when smoke came into the cockpit. The plt made a precautionary landing on a blacktop road. The road was the best available, but was not adequate and acft flipped forward to the inverted position.…NTSB LAX87DJA01Accident · No injuriesFinal reportMurrayair MA-1 · Hilo, HIAfter returning from a spraying flt, the acft was refueled. After refueling, the plt used fuel to wash oil from the side of the acft & the wing step. When the eng was restarted about 2 min later, fuel fumes ignited & fire spread to the fuel truck. Both the…NTSB LAX87FA016Accident · No injuriesField investigationFinal reportBeech K35 · Bakersfield, CAThe flight was in level cruise at an altitude of 3,500 feet when the engine began to run rough. A precautionary landing was made. As the aircraft was touching down, tower personnel notified the pilot that the aircraft was on fire. The pilot evacuated the…NTSB SEA87IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Seattle, WADuring attempt to apply ground power to acft, internal feeder cables shorted and melted down. Investigation revealed poor workmanship by contracted maintenance personnel in modification installation.NTSB LAX86LA359Accident · No injuriesLimited investigationFinal reportCameron 0-77 · Tiburon, CAAfter completing an aerial advertising flight across the san francisco bay, the plt attempted a landing on up-sloping terrain. The terrain was steeper than anticipated & the plt became distracted. The plt forgot to turn off the pilot light to the left burner.…NTSB DEN86IA235Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COTwa flt 735 landed at Denver stapleton arpt. During the taxi to the passenger terminal, a fire erupted in the tailpipe of the left engine. The flt crew executed the emergency evacuation procedures. Fire was extinguished. With no damage to the acft or engine.…NTSB MKC86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250T · Norfolk, NEA fire started inflight in the left wheel well and nacelle area just after the pilot turned on the electric fuel pumps during the turn to final approach. The airplane was landed and the pilot evacuated safely. According to witnesses, the airplane appeared to…NTSB MKC86FA151Accident · 3 fatalField investigationFinal reportWhittman WD (Bigx) · Sheldahl, IAWitnesses state that they saw two airplanes, one silver and one red, climbing northbound to cruise altitude in loose formation when the red aircraft's engine backfired and the antique fabric-covered aircraft started burning. Flames five to eight feet in…NTSB LAX86LA290Accident · No injuriesLimited investigationFinal reportCessna 195B · San Diego, CAThe airplane departed montgomery airport, runway 28L, San Diego, CA. Shortly after departing a fire erupted in the upper cowling area. The pilot executed an emergency landing on runway 05, but landed hard. Examination of the wreckage disclosed the number 2…NTSB NYC86LA156Accident · No injuriesLimited investigationFinal reportBeech B-60 · Toms River, NJAn inflight fire occurred shortly after takeoff. Smoke was observed trailing from the right eng & it was shut down. The plt returned & landed at the arpt. After landing, the fire was extinguished by linemen, a fireman & plts who were standing by. An…NTSB ATL86LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Pelion, SCThe private plt and student plt returned to the acft after pausing from landing practice for a soft drink. An engine start was attempted and a back fire occurred that started and induction fire. The intensity of the fire grew and the occupant exited the acft…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…NTSB SEA86LA134Accident · No injuriesLimited investigationFinal reportAyres S2R · Hamer, IDDuring aerial application the engine ceased operating and a small fire erupted. During forced landing the landing gear was torn off and the fuselage became twisted. After landing, the fire continued for a short period of time. Postaccident eng teardown…NTSB FTW86FRG19Accident · 1 fatalFinal reportSoward Rutan Longeze · Georgetown, TXThe acft crashed after hitting trees on short final following an inflight fire and an eng failure. The acft was on it's first flt following an eng overhaul and had been airborne about 2 minutes when ground and air observers noticed smoke trailing from the eng…NTSB DEN86LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAcft carburetor had been removed for maintenance and sign posted in acft to this effect. Student plt called to schedule acft and was put in another acft. Scheduler said plt was told acft was out of service but plt claimed he did not hear this. Plt met flt…NTSB FTW86IA078Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Dallas/Ftw Apt, TXThe crew stated that during an attempted start the no. 1 eng failed to gain ignition during the prescribed 25 sec limit and that they aborted the start. Shortly thereafter, grnd pers reported that the eng had developed a tail pipe fire. Following emerg…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,…NTSB LAX86LA193Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Keaau, HIA hiller 1100 was destroyed by fire after a forced landing. The plt indicated that the EGT had risen to approximately 800 deg c from 700 deg and then rose to 1100 deg. The heat warning light illuminated. The plt initiated a precautionary landing. The eng…NTSB MKC86LA085Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jackson, MOIn cruise flt the PIC smelled something burning and noticed black and white smoke pouring fm the eng cowling. This was followed by a partial loss of pwr. A precautionary landing was made in a field. The PIC noticed flames erupting fm the eng area after…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…NTSB ATL86FA085Accident · No injuriesField investigationFinal reportBeech BE-90 · Mount Pleasant, TNOn final approach the crew turned the aircraft cabin environmental control from the auto mode to the off position. Shortly thereafter, the cockpit and cabin began to fill with smoke. The occupant of the copilots seat felt heat around his feet. A normal…NTSB SEA86IA058Incident · No injuriesIncident investigationFinal reportCessna T210 · Roche Harbor, WAOn initial climb after takeoff, electrical fire broke out in back of pilot's yoke. Pilot managed to extinguish five- inch flames by hand, climbed to 2000 feet and evaluated situation. Noting no further problems, flight was continued to destination. Enroute,…NTSB FTW86LRD06Accident · No injuriesFinal reportAir Tractor AT301 · Gilbert, LAOn January 29, 1986, an airtractor AT310, N5218S, owned by halcom flying service, was substantially damaged due to a fire which occurred during an attempted engine start. N5218S was to be flown to another location for maintenance purposes.NTSB ATL86LA052Accident · No injuriesLimited investigationFinal reportCessna 150M · Whiteville, NCThe student plt had moved the aircraft closer to the terminal about 15 minutes prior to this attempted start. He tried several times but it would not start. The plt then primed the eng several times. His wife shouted to him that the aircraft was on fire. His…NTSB DCA86AA012Accident · 7 fatalFinal reportDouglas DC-3 · Dekalb, TXAt 1708:48, while cruising at 6000', a pilot of N711Y advised ATC, 'I think I'd like to turn around, head for texarkana here, I've got a little problem.' He was provided a vector & advised of closest airports. Shortly after, he stated he would be unable to…NTSB ATL86LA044Accident · No injuriesLimited investigationFinal reportHughes 269B · Stone Mountain, GADuring ground refueling of the aircraft the fuel tank was over- filled and the fuel spilled over onto the ramp. The fuel was ignited and the aircraft was destroyed by fire.NTSB CHI86FEX04Accident · No injuriesFinal reportBeech E18S · Fort Wayne, INThe acft experienced a right eng fire during eng start. The plt reported the right eng would not start during the first attempt. During the second attempt at starting the eng, it started. While running the eng on the primer, the plt heard a loud bang and saw…