NTSB investigations
450 cases where the first occurrence was “Fire”.
Cases per year
| 1982 | 27 |
|---|---|
| 1983 | 25 |
| 1984 | 21 |
| 1985 | 30 |
| 1986 | 28 |
| 1987 | 28 |
| 1988 | 15 |
| 1989 | 20 |
| 1990 | 14 |
| 1991 | 16 |
| 1992 | 17 |
| 1993 | 14 |
| 1994 | 22 |
| 1995 | 20 |
| 1996 | 11 |
| 1997 | 15 |
| 1998 | 13 |
| 1999 | 9 |
| 2000 | 12 |
| 2001 | 17 |
| 2002 | 15 |
| 2003 | 7 |
| 2004 | 12 |
| 2005 | 12 |
| 2006 | 13 |
| 2007 | 17 |
Where
Open the mapLatest cases
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 NYC08IA069Incident · No injuriesIncident investigationFinal reportPiper PA-32R · Destin, FLAn in-flight fire due to a fractured fuel injector line as a result of an unauthorized repair to the line.NTSB SEA08LA014Accident · No injuriesLimited investigationFinal reportRaytheon Corporate Jets Hawker 800XP · Santa Ana, CAThe failure of the pilot-in-command to follow procedures stipulated in the airplane flight manual regarding brake cooling time periods. Factors contributing to the accident were the intentional aborted takeoffs which resulted in the hot brakes, and the…NTSB SEA08CA004Accident · No injuriesData collectionFinal reportPiper PA 28-151 · Salt Lake City, UTThe leak at the fuel line fitting, which resulted in a fire during engine start.NTSB DEN07LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Taos, NMThe unsecured B-nut fitting to the fuel return line which allowed for fuel spillage, an engine fire, and fuel exhaustion that led to the engine's subsequent failure. a factor contributing to the accident was the pilot's intentional wheels up landing in rough,…NTSB DCA07MA310Accident · No injuriesClass 1 · MajorFinal reportMcdonnell Douglas DC-9-82 (MD-82) · St. Louis, MOAmerican Airlines’ maintenance personnel’s use of an inappropriate manual engine start procedure, which led to the uncommanded opening of the left engine air turbine starter valve, and a subsequent left engine fire, which was prolonged by the flight crew’s…NTSB LAX07LA263Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Modesto, CAThe failure of the airplane's exhaust muffler during takeoff that was due to an inadequate annual inspection. Contributing to the accident were the pilot's inadequate inspection to isolate the smoke source, and the pilot's decision to continue flight with an…NTSB DEN07LA148Accident · 2 fatalLimited investigationFinal reportElliott Cirrus VK30 · Watrous, NMThe pilot's failure to maintain control of the airplane during a forced landing that resulted in a hard landing. Contributing to the accident was the ruptured pressurized oil line.NTSB NYC07MA162Accident · 5 fatalClass 1 · MajorFinal reportCessna 310R · Sanford, FLActions and decisions by National Association for Stock Car Auto Racing's corporate aviation division's management and maintenance personnel to allow the accident airplane to be released for flight with a known and unresolved discrepancy, and the accident…NTSB CHI07CA189Accident · Minor injuriesData collectionFinal reportCameron Balloons Z-77 · Battle Creek, MIThe whisper burner's fuel valve opening for undetermined reasons, which resulted in a fire after landing. A factor in the accident was the balloon envelope's parachute top not reseating.NTSB ANC07FA047Accident · No injuriesField investigationFinal reportPiper PA-32-300 · Kake, AKA fractured exhaust manifold, which resulted in an in-flight fire, and the inadequate inspection of the airplane by the operator's maintenance personnel.NTSB DFW07CA125Accident · Minor injuriesData collectionFinal reportCessna A188B · Happy, TXAn in-flight fire while maneuvering for an undetermined reason.NTSB SEA07FA124Accident · 1 fatalField investigationFinal reportCessna P210N · Spanish Fork, UTAn engine oil line leak and subsequent engine compartment fire while in cruise flight.NTSB SEA07LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Chiriaco Summit, CAEngine fire during start-up for undetermined reasons.NTSB SEA07LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lincoln, CAAn in-flight fire occurred during the initial climb as a result of the aviation maintenance technician's failure to sufficiently tighten the b-nut that was found disconnected post-accident. A contributing factor was the engine manufacturer's failure to…NTSB ATL07LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Woolsey, GAIn-flight fire of the right wing for undetermined reasons.NTSB NYC07IA063Incident · No injuriesIncident investigationFinal reportAirbus A-320-232 · New York, NYThe in-flight fire which was caused by the catastrophic failure of a 9-volt battery from an unknown cause.NTSB ATL07LA034Accident · No injuriesLimited investigationFinal reportGreenhaw, William Lancair 360 · Guntersville, ALFailure of an unapproved automotive fuel line installed by the owner/pilot mechanic which resulted in an engine fire during taxi after landing.NTSB DEN07IA037Incident · Minor injuriesIncident investigationFinal reportBoeing 737-824 · Colorado Spring, COA short circuit in the primary (non-rechargeable) battery, most likely due to it being recharged. This internal short led to thermal runaway, battery failure, and an explosion.NTSB LAX07CA028Accident · Minor injuriesData collectionFinal reportStrategie Ballloon Amazon · Page, AZThe pilot's failure to identify grass clippings in the balloon envelope during a preflight inspection, which resulted in the balloon catching fire in flight.NTSB ATL07CA015Accident · No injuriesData collectionFinal reportCessna 172G · Dalton, GAThe pilot's improper starting procedures, which resulted in an on-ground engine fire.NTSB DFW07IA018Incident · No injuriesIncident investigationFinal reportBell 206-L4 · Abbeville, LAA fire in the baggage area for undetermined reasons.NTSB DEN06CA124Accident · No injuriesData collectionFinal reportBell 47G-2 · Hayden, ALengine fire for reasons undetermined.NTSB MIA06IA133Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Miami, FLThe pilot's inadvertent application of the left brakes at touchdown. Contributing to the incident was insufficient information in the quick reference handbook on the loss of touchdown protection with an inoperative anti-skid system.NTSB LAX06LA271Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Morgan Hill, CAExcessive fuel flow through the carburetor which resulted in leaking fuel, and subsequent in-flight fire while maneuvering.NTSB LAX06FA238Accident · No injuriesField investigationFinal reportLearjet 55 · Van Nuys, CAAn in-flight fire of undetermined origins.NTSB CHI06CA155Accident · No injuriesData collectionFinal reportMcFarland Rotorway Exec · Mooresville, INAn in-flight fire for undetermined reasons.NTSB ATL06IA071Incident · No injuriesIncident investigationFinal reportBeech C90A · Raleigh, NCThe inadequate manufacturing process, which resulted in a windshield fire and subsequent emergency landing.NTSB DFW06LA104Accident · Minor injuriesLimited investigationFinal reportCessna 210F · Lubbock, TXAn in-flight electrical fire for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06IA054Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Asheville, NCThe improper installation of the pilot's windshield by company maintenance personnel, which resulted in flame and smoke in the cockpit, and subsequent emergency landing.NTSB DCA06MA022Accident · Minor injuriesClass 1 · MajorFinal reportDouglas DC-8 · Philadelphia, PAan in-flight cargo fire that initiated from an unknown source, which was most likely located within cargo container 12, 13, or 14. Contributing to the loss of the aircraft were the inadequate certification test requirements for smoke and fire detection…NTSB DFW06LA038Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXThe pilot's excessive taxi speed and his excessive use of brakes.NTSB CHI06CA025Accident · Minor injuriesData collectionFinal reportPiper PA22-150 · Canton, ILThe fire for undetermined reasons.NTSB NYC05LA131Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Farmingdale, NJA fire that originated at the right main landing gear brake caliper and piston, during taxi, which resulted in substantial damage to the airplane.NTSB CHI05CA209Accident · No injuriesData collectionFinal reportNational Ballooning 751-12 · Indianola, IAThe in-flight fire due to the loose fuel line connection as a result of the pilot's inadequate preflight. A factor was the power lines.NTSB CHI05CA210Accident · No injuriesData collectionFinal reportBarr Barr Six · Knox, INThe undetermined cause of the fire during the taxi.NTSB ANC05LA110Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Ketchikan, AKAn electrical arc on the exterior of a fuel pressure line that initiated a fuel leak and fire during cruise flight, which resulted in serious injuries to the pilot as he performed an emergency landing on the water. A factor contributing to the accident was an…NTSB IAD05LA095Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Branchville, NJAn electrical fire of unknown origin. A factor in the accident was the pilot's failure to perform the In-Flight Electrical Fires checklist.NTSB CHI05LA173Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Crete, ILThe separation of the drive belt, during cruise, leading to the puncturing of the oil cooler and subsequent fire. An additional cause was the pilot's restricted lookout during the emergency landing resulting in the hard landing.NTSB ANC05LA085Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Skwentna, AKThe pilot's improper loading of externally carried lumber that caught fire due to exposure to hot exhaust gases during cruise flight, which resulted in an emergency descent/landing and subsequent collision with a gravel bar. A factor contributing to the…NTSB MIA05LA106Accident · Minor injuriesLimited investigationFinal reportPitts S1S · Lake Wales, FLImproper maintenance inspection by other maintenance personnel, which resulted in a loose fuel line fitting going undetected, a fuel leak onto exhaust piping, and a fire.NTSB LAX05LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Half Moon Bay, CAThe pilot's excessive braking during taxi that resulted in the right brake overheating and a fire. A factor in the accident was the pilot's continued operation with known deficiencies.NTSB LAX05FA108Accident · No injuriesField investigationFinal reportCessna 210L · Oxnard, CAA pinhole leak in the fuel pressure line during the takeoff roll that was ignited by an electrical arc associated with wires adjacent to the fuel line. A contributing factor in the accident was the failure of maintenance personnel to comply with a…NTSB ANC05IA020Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Anchorage, AKThe failure of a high-pressure fuel line fitting, which resulted in an engine fire during takeoff/initial climb.NTSB ATL05IA025Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Peachtree City, GAThe failure of maintenance personnel to properly torque a fuel line fitting, which resulted in a fuel leak and in-flight engine fire.NTSB IAD05LA005Accident · No injuriesLimited investigationFinal reportBeech C24R · Hyannis, MAThe mechanic's failure to secure the fuel pressure line to the fuel pressure gauge fitting, which resulted in an engine compartment fire and a subsequent loss of engine power.NTSB ANC05LA003Accident · No injuriesLimited investigationFinal reportScan 30 · Anchorage, AKAn in-flight fire during cruise flight for an undetermined reason.NTSB LAX04LA334Accident · No injuriesLimited investigationFinal reportBritish Aerospace BAE 125-1000A · San Francisco, CAAn electrical arc from an undetermined source initiated a hydraulic line rupture, which resulted in an equipment bay fire.NTSB ANC04LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cantwell, AKAn in-flight fire for an undetermined reason, which resulted in an off-airport forced landing and subsequent destruction of the airplane by fire.NTSB CHI04LA295Accident · Serious injuriesLimited investigationFinal reportAero Commander Callair A-9B · Norton, KSThe fire in the area of the fuel line and the unsuitable terrain encountered during an emergency landing by the pilot. Contributing factors were the pole.NTSB ATL04LA153Accident · 1 fatalLimited investigationFinal reportConvair Div. of Gen. Dynamics 440 · Beef IslandThe in-flight fire on the number two engine, for undetermined reasons.