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 FTW84FA038Accident · No injuriesField investigationFinal reportDouglas DC-3-3C · Laredo, TXThe original flt was aborted due to a magneto problem. The defect was corrected, but due to the delayed takeoff, the plt elected to fly to mcallen, TX, for further repairs. During the takeoff roll, the aircrew noted sparks/flares on the left side of the…NTSB LAX84LA035Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Chino, CAThe acft experienced an in-flt fire on the downwind leg of the traffic pattern during a flt test following routine maintenance. The plt stated that while flying at 500 ft AGL in the traffic pattern smoke began entering the cockpit. Allgauges and systems…NTSB SEA84FA005Accident · Serious injuriesField investigationFinal reportHordemann RV-4 · Kootenai, IDAccording to the plt he was cruising at 11500 MSL when smoke started coming from the lower forward section of the cockpit and a fire developed around his feet. The engine was shut down and the fire subsided or went out. During the glide for landing the engine…NTSB MIA84LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Miami, FLWhile in a descending spiral the plt stated that the cockpit filled with smoke. He proceeded to turn off the electrical master switch. Shortly aft the eng failed and the acft was ditched in 480 ft of water.NTSB FTW83LA418Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Belen, NMThe student & instructor plt (CFI) had flown the acft from albuquerque to Belen, NM, & had shut down the eng. During an eng start to continue the flt about 20 min later, a fire started in the eng & the acft was destroyed by fire. The source of the fire was…NTSB DEN83LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Grand Junction, COThe CFI stated that while practicing emergency landings, smoke started billowing into the cockpit. She also noticed a lot of heat near her legs. Thinking that there might be a fire on the other side of the firewall, the CFI decided to land in a corn field.…NTSB ATL83LA347Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Blackshear, GAThe pilot stated that during a spray run, a vibration was felt, the engine backfired and flames erupted from the right underside of the cowling. Power was lost continuously until over the landing strip at 50 feet AGL when all power was lost. The acft landed…NTSB MIA83FA216Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Marathon, FLThe acft landing gear collapsed during a forced landing due to a cabin fire. The landing occurred just short of the rwy at Marathon arpt, FL. The plt had departed this arpt about 30 minutes earlier on the 2nd leg of a student x-country flt. The departure was…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…NTSB LAX83LA378Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cantua Creek, CAThe plt report that while he was applying sulfur to a tomatoe field, sulfur dust, which had accumulated in the cockpit, ignited. He elected to make an emergency landing in an adjacent cotton field which was muddy from irrigation. After touchdown, the main…NTSB CHI83LA341Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Plainfield, WIThe acft caught fire in the air after a power loss. A forced landing was accomplished and the pilot escaped without injury but the acft was destroyed by the fire. It was reported that the fire was so intense that all evidence of cause was destroyed. The acft…NTSB LAX83LA359Accident · No injuriesLimited investigationFinal reportCessna TR182RG II · Bishop, CAThe acft caught fire during taxi after an aborted takeoff. During the takeoff roll the plt noticed a vibration and a slight pulling to the left. The brakes and engine had been checked with nothing noted but the plt decided to abort. He let the acft roll to a…NTSB LAX83IA331Incident · No injuriesIncident investigationFinal reportConvair 440 · Point Mugu, CAAn engine fire erupted during the climb to cruise. Following an emergency landing it was determined that there was a loose primer line fitting at the carburetor in the area of the greatest fire damage.NTSB FTW83LA293Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Marion, TXThe acft collided with fences during a forced landing after an engine fuel fire. The left exhaust pipe failed and the misdirected heat burned through a fuel line. The fuel ignited filling the cockpit with smoke. The engine quit due to fuel starvation and the…NTSB ANC83FA103Accident · No injuriesField investigationFinal reportDouglas DC-3 · Fort Yukon, AKThe acft had an in-flt fire in the accessory section of the lt eng. According to the passenger there was a long delay between outbreak of fire and corrective action by the crew. The passengers also commented on the lack of communication from the cockpit to…NTSB FTW83LA264Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Rio Grande City, TXThe acft was destroyed by fire during an emergency landing. Shortly after depature the acft cockpit filled with heavy smoke. The plt attempted to return to the arpt but could not because of the heavy smoke in the cockpit. Efforts to eliminate it were…NTSB DCA83AA028Accident · 23 fatalFinal reportDouglas DC-9-32 · Covington, KYThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/02. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm At…NTSB MKC83IA116Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Kansas City, MODuring descent an electric wire bundle shorted behind the flight engineers panel, a fire erupted with smoke. The flight engineer used a portable fire extinguisher to put out the fire.NTSB ATL83FA174Accident · 2 fatalField investigationFinal reportPiper PA 32RT-300T · Murfreesboro, TNThe acft crashed in an open field after an in-flt fire. The fire started while the acft was cruising. No emergency callswere made and the engine which was the fire source was not shut down. A rear seat passenger said he tried to open a reardoor to let out…NTSB LAX83LA200Accident · No injuriesLimited investigationFinal reportBeech E-18S · Davis, CAWhile in flt on a parachute jumping mission, a fire erupted in the right eng area & a precautionary landing was made. An exam revealed that the float fulcrum screw, pn 13773, on the stromberg carburetor had backed out & allowed fuel to escape into the exhaust…NTSB MIA83LA108Accident · Minor injuriesLimited investigationFinal reportCessna 182 RG · Palm Beach, FLThe acft ditched in the atlantic ocean 5 miles east of Palm Beach FL after an electrical fire and engine failure. The pilot said he departed boca raton at 1950 EST. A few minutes later he experienced an electrical fire and electrical failure. About 2 minutes…NTSB ANC83IA053Incident · No injuriesIncident investigationFinal reportCessna 401 · Bethel, AKThe acft right engine started emitting sparks from the cowling during normal cruise. The pilot noted a drop in manifold pressure so he reduced power on that engine and the sparks stopped. The acft was landed at Bethel. The fire dept. Used a fire extinguishing…NTSB FTW83FA100Accident · No injuriesField investigationFinal reportRobinson R22 · Zapata, TXThe helicopter was landed in an area of dry grass, 18 to 28 inches tall. The plt stated that within 30 sec after a normal approach & touchdown, the passenger noticed a fire as he was exiting the acft. The pilot then rolled the throttle on in an attempt to…NTSB MIA83FA046Accident · 3 fatalField investigationFinal reportPiper PA-601P · Valparaiso, FLTwo minutes after takeoff the plt reported a loss of the left eng. He was immediately cleared for a landing at eglin afb. While maneuvering for a landing the left eng & wing separated from the acft. The eng was separated from the wing & showed evidence of in…NTSB ATL83IA054Incident · No injuriesIncident investigationFinal reportGulfstream American G-159 · Chamblee, GAOrion airlines flt 110 experienced an engine fire immediately after tkof from dekalb-peachtree airport. At 400 ft AGL, the rt engine fire warning lt illuminated. Flames were observed over the wing and coming from the inbd side of the right eng cowl. The rt…NTSB LAX83FA035Accident · No injuriesField investigationFinal reportPiper 601P · Tonopah, NVAs the acft reached 15,500 ft, aprx 30 mi from the dep arpt, the plt & pax noted fumes that irritated the eyes & caused dizziness & breathing difficulties. The plt reversed course, then elected to make an emerg lndg on a dirt road. Drg the lndg roll-out, the…NTSB MIA83LA029Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Belle Glade, FLAcft had been object of an airborne pursuit by U.S. Customs at about 1830 in the vicinity of Belle Glade. During the pursuit the acft door & 15 bales of a controlled substance were observed being jettisoned from the acft. After landing the acft was set on…NTSB ATL83IA028Incident · No injuriesIncident investigationFinal reportConvair 340 · Greenboro, NCThe pilot stated that while at cruise at 4000 feet that there was a sharp jolt in the airframe and on further investigation discovered that the left engine was on fire. The propeller stopped turning shortly thereafter. Immediately the pilot pulled the…NTSB FTW83FA001Accident · 4 fatalField investigationFinal reportThunder Balloons AX9-140 · Albuquerque, NMAfter what was described as a normal landing liquid propane began escaping. The propane vaporized & was ignited engulfing the gondola in flames. Four pax exited the gondola while it was still on the ground & the last survivor exitedat about 25 ft as the…NTSB ATL82FKJ14Accident · Serious injuriesFinal reportGrumman G-164 · Bay Minnette, ALThe pilot reported that during takeoff, he noticed extreme heat in the cockpit and the engine began to surge, then lose power. He landed on the remainder of the runway and stopped after running off the end. However, the engine was on fire and the plane was…NTSB NYC82DA214Accident · No injuriesFinal reportAero Commander 112TC · Morristown, NJWhen pilot extended gear for landing a fire started. The fire continued after landing and pilot was unable to extinguish it. Fire department arrived within 30 minutes but aircraft was destroyed.NTSB MKC82IA169Incident · No injuriesIncident investigationFinal reportCessna 421C · St. Louis, MOPilot reported, the flight encountered icing conditions near St. Louis and the propeller de-ice system was activated. When de-ice system was turned on, flames shot out from the lower right corner of the pilot's instument panel where the de-ice ammeter is…NTSB CHI82FA312Accident · 2 fatalField investigationFinal reportTaylorcraft BL-65 · Rock Falls, ILAircraft caught fire while performing aerobatics and crashed out of control. Gas tank cap had come off and during inverted flight fuel spilled out and ignited.NTSB ANC82IA074Incident · No injuriesIncident investigationFinal reportCessna 207 · Near Anvik, AKDuring a deadheading flight back to his operations base, the pilot experienced an inflight fire and smoke in the cockpit. After he extinguished the fire and evacuated the smoke, a normal landing was made. Examination of the aircraft revealed that the…NTSB ATL82FA229Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Raleigh, NCShortly after takeoff the acft caught fire. The plt attempted to turn back to the arpt but the eng lost power & the acftcould not maintain altitude. The acft crashed into a heavily wooded state park. The #5 cylinder exhaust pipe was found separated & was not…NTSB ATL82DA223Accident · No injuriesFinal reportAero Commander 680FL · Alabaster, ALPrior to the post-maintenance inspection flight the pilot/owner, who is a certificated A&P mechancic, had been calibrating the fuel flow on the right eng fuel injector pump. An external line had been connected to the fuel flow transmitter fitting of the fuel…NTSB DEN82DA146Accident · Minor injuriesFinal reportPiper PA-23C-250 · Gunnison, CODuring takeoff, the pilot was distracted by inbound traffic and delayed retracting his gear. At the same time, the engines were not synchronized and he was having difficulty getting them to sound good. He then noticed that a fire had started in the vicinity…NTSB NYC82FA134Accident · No injuriesField investigationFinal reportPiper PA-31 · Bennington, VTWhile on approach to land, the pilot noticed the aircraft's gear warning lights were out and the circuit breakers were tripped. The pilot advised operations and started a fly-by when he noticed a fire in the left engine. The pilot feathered the left engine…NTSB MIA82DA139Accident · No injuriesFinal reportCessna 310 · Near Horseshoe, FLThe pilot reported that during an over water flight, he noticed the right engine fuel flow was fluctuating while the engine was cutting in and out. This was followed by intense white smoke which was observed coming out of the louvers on top of the engine…NTSB ATL82IA159Incident · No injuriesIncident investigationFinal reportPiper PA-31-325 · Asheboro, NCDuring cruise at 5000 ft the pilot smelled electrical fumes and noticed smoke filling the flap indicator gauge. He pulled the wing flap circuit breaker but moments later volumes of smoke arose from under the instrument panel, with flames observed behind the…NTSB NYC82DA085Accident · No injuriesFinal reportRayan NAV-4 · Bloomsburg, PAAfter takeoff the pilot smelled smoke and observed the oil pressure drop to 20 PSI. When the oil pressure continued to drop the pilot decided to land at Bloomsburg airport, approximately 3 miles away. After landing the pilot taxied off the runway and the…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…NTSB ATL82FA089Accident · 3 fatalField investigationFinal reportBeech B35 · Louisville, KYThe aircraft crashed on approach during an attempted emergency landing. The aircraft had just departed and was returningbecause of smoke in the cockpit. The smoke was caused by an electrical short and arcing of wiring in the system. The loose wiring and worn…NTSB ATL82IA103Incident · No injuriesIncident investigationFinal reportPiper PA-31P · Savannah, GADuring flight, electrical fumes, smoke and sparks began emitting from the circuit breaker panel immediately left of the pilot's seat. The pilot was forced to move to the right seat. He tried to suppress the sparks with a chemical fire extinguisher and tried…NTSB FTW82FA109Accident · 2 fatalField investigationFinal reportBeech B35 · Dulce, NMApproximately 30 min after departure the acft returned to the arpt trailing smoke & occassional flame from an area near the cowl flaps & nose gear doors. The plt did not make a straight in approach but appeared to be in a normal traffic pattern. The acft…NTSB LAX82IA103Incident · No injuriesIncident investigationFinal reportDouglas DC-9-82 · Long Beach, CADuring engine start, ground personnel reported over the intercom to the pilots that fuel was dripping from the no. 2 engine as it was spooling up and called for continued motoring with the fuel lever off. When ground personnel then reported a fire the captain…NTSB DCA82AA016Accident · 1 fatalFinal reportde Havilland DHC-6 · Providence, RIAprx 15 min aft tkof, lgt icg was noted on the windshield. The aircrew activated the windshield washer/deice sys which used isopropyl alcohol. However, only a little deicing fluid was noted on either side. The sys was activated again. Aft hldg the sw svrl…NTSB ATL82FA052Accident · No injuriesField investigationFinal reportCessna 401 · Jessup, GAAfter reaching a cruise altitude of 9500 feet the pilot noticed smoke coming out of the left engine cowling. He then proceeded to reduce the left throttle but was unable to move the lever. According to the pilot the fire was extinguished when the left fuel…NTSB ATL82DA049Accident · Minor injuriesFinal reportCessna C-172 · Brownsville, KYWhile climbing after takeoff, the pilot noticed smoke in the cockpit. He reported that flames started to come in as he was turning back to the airstrip. When he saw that he could land back on the strip, he reportedly shut- off the fuel, master switch and…NTSB CHI82FEE12Accident · No injuriesFinal reportCessna 172RG · Wheeling, ILThe pilot stated that after the aircraft was started and warmed up approximately five to ten minutes the engine was shut down to investigate frozen brake pads. After the brake pads were freed the engine was restarted and during cranking the pilot noticed…