NTSB investigations
354 cases where the sequence of events included Fire/smoke (post-impact).
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '170' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '170' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN12FA043Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 76 · Fort Worth, TXThe flight instructor's failure to maintain airspeed above the air minimum control airspeed (Vmca), which resulted in a loss of control and impact with terrain. Contributing to the accident was the instructor's failure to follow published procedures to…NTSB ERA12LA048Accident · No injuriesLimited investigationFinal reportBeech C23 · Columbia, MSThe partial loss of engine power for undetermined reasons during takeoff.NTSB CEN11LA669Accident · Serious injuriesLimited investigationFinal reportOwen Vans RV-10 · Marietta, OHThe in-flight engine fire and loss of engine power due to an improperly installed fuel injector nozzle during a recent engine overhaul.NTSB CEN11FA444Accident · 1 fatalField investigationFinal reportBoeing B75N1 · Wetmore, COThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.NTSB ERA11FA354Accident · 2 fatalField investigationFinal reportBeech C24R · Valparaiso, FLThe pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.NTSB ERA11CA340Accident · No injuriesData collectionFinal reportMooney M-20G · Monroeville, PAThe pilot’s failure to maintain airplane control during takeoff.NTSB CEN11LA484Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Cash, ARA loss of engine power for undetermined reasons.NTSB ERA11FA312Accident · 4 fatalField investigationFinal reportBeech 58 · Murphy, NCAn in-flight fire that mostly likely occurred in the right front cockpit area behind the instrument panel and below the glare shield; the origin of the fire could not be determined because of the extensive fire damage.NTSB CEN11FA346Accident · 1 fatalField investigationFinal reportHansen IB C Cassutt III M · Erie, COThe pilot's incapacitation due to a cardiac event.NTSB ERA11CA294Accident · Minor injuriesData collectionFinal reportPiper PA-23-250 · Clayton, NYThe pilot's failure to obtain a proper touchdown point while landing with a gusting tailwind.NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB CEN11FA253Accident · 3 fatalField investigationFinal reportPiper PA46-350P · Monroe, MIThe pilot's demonstration of poor judgment by attempting a high-speed pass several feet above the runway and his subsequent failure to maintain clearance from the runway.NTSB CEN11LA254Accident · No injuriesLimited investigationFinal reportNorth American B25 · Encinal, TXThe co-pilot’s premature retraction of the landing gear during takeoff, which resulted in a gear collapse and impact with the runway surface.NTSB CEN11CA163Accident · Minor injuriesData collectionFinal reportMooney M20R · Cypress, TXThe student pilot’s delayed decision to execute a go-around.NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB CEN11FA008Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Springfield, MOThe pilot's failure to maintain control of the airplane during an attempted go-around, which led to an aerodynamic stall.NTSB ERA10WA510Accident · 1 fatalForeign investigationRobinson R44 · Davinopolis, BrazilOn September 30, 2010, about 0844 local/1144 UTC, a Robinson R44 II, Brazilian registration PR-CCO, registered to and operated by a private individual, was landed in rugged terrain near Davinopolis, State of Maranhao, Brazil. Weather conditions and flight…NTSB ERA10LA488Accident · 1 fatalLimited investigationFinal reportSchulman Mosquito XEL · Halifax, MAThe pilot's loss of control while hovering. Contributing to the accident was the pilot’s limited experience operating the helicopter make and model.NTSB CEN10LA442Accident · 1 fatalLimited investigationFinal reportLunceford Sparrowhawk II · Tell City, INThe pilot's loss of control of the gyroplane for undetermined reasons.NTSB CEN10LA422Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · McCook, NEThe pilot's inadequate visual lookout during taxi, which resulted in a collision with a parked airplane.NTSB ERA10LA297Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Rockohoma, NYThe pilot's inadequate preflight inspection which resulted in a total loss of engine power during the initial climb due to fuel contamination.NTSB CEN10FA291Accident · 2 fatalField investigationFinal reportBell 222 · Midlothian, TXThe fracture of a swashplate drive pin as a result of hydrogen embrittlement due to an unknown source, which resulted in an in-flight breakup of the main rotor system during cruise flight.NTSB CEN10LA255Accident · Minor injuriesLimited investigationFinal reportSupinski Mark R Supinski Mustang II · Peyton, COThe pilot’s failure to maintain control of the airplane during landing. Contributing to the accident was the pilot’s lack of experience flying tailwheel configured airplanes.NTSB CEN10CA185Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malden, MOThe pilot's failure to maintain clearance from a tree during an aerial application flight.NTSB ERA10FA178Accident · 1 fatalField investigationFinal reportBeech 95 · Lagrange, NYThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB CEN10FA130Accident · 2 fatalField investigationFinal reportBeech C24R · Bristow, OKThe pilot’s loss of control for undetermined reasons while maneuvering at low altitude.NTSB ERA10LA102Accident · 1 fatalLimited investigationFinal reportDavis Michael J Longez · Dexter, KYThe loss of engine power due to the chaffing and grounding of the single magneto's ignition lead.NTSB CEN10FA069Accident · 1 fatalField investigationFinal reportBeech A36 · Eagle Pass, TXThe pilot's decision to continue the approach below minimums without visual references, and subsequent collision with the perimeter fence/terrain.NTSB ERA10LA066Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Newcomb, NYThe pilot’s failure to maintain clearance from mountainous terrain during descent at night, with low clouds and fog.NTSB CEN10LA041Accident · 2 fatalLimited investigationFinal reportWicks Air Center Hornet · Bonham, TXThe pilot's loss of control shortly after takeoff due to spatial disorientation in fog and/or low-level clouds.NTSB CEN10LA034Accident · 2 fatalLimited investigationFinal reportPiper PA-18-135 · Sikeston, MOThe pilot's failure to maintain directional control during a crosswind takeoff.NTSB CEN10FA027Accident · 2 fatalField investigationFinal reportCommander 114-B · Adrian, MIThe pilot did not maintain control of the airplane due to spatial disorientation while on an instrument approach in instrument meteorological conditions.NTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.NTSB WPR09CA470Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Mt Charleston, NVThe pilot's failure to maintain aircraft control and terrain clearance while maneuvering at a low altitude above high terrain. Contributing to the accident was a downdraft and high density altitude.NTSB CEN09LA605Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Troy, MIA loss of engine power during initial climb due to fuel starvation as a result of the pilot's selection of an empty or nearly empty main tank for takeoff.NTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.NTSB ERA09FA526Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Fort Lauderdale, FLFatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…NTSB ERA09LA523Accident · No injuriesLimited investigationFinal reportCessna 208 · Sheffield, MAA total loss of engine power due to a failure of the 1st stage sun gear output splines for unknown reasons, which resulted in a power turbine overspeed condition, with subsequent blade distress/release.NTSB WPR09LA431Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oroville, CAA total loss of engine power for undetermined reasons.NTSB CEN09LA538Accident · 2 fatalLimited investigationFinal reportBrown Joseph B JR RV-6 · Ama, LAThe pilot’s failure to maintain directional control during takeoff.NTSB ERA09LA454Accident · 1 fatalLimited investigationFinal reportPongracz John M Nieuport 1 · Brasstown, NCThe pilot’s failure to maintain adequate airspeed during climb after takeoff, resulting in an inadvertent stall.NTSB CEN09CA498Accident · Minor injuriesData collectionFinal reportRans Employee Flying Club Rans S-6S · Montezuma, INThe pilot's failure to maintain aircraft control after takeoff resulting in an impact with a power line and the ground.NTSB CEN09FA430Accident · Serious injuriesField investigationFinal reportBeech 35-A33 · Las Vegas, NMThe loss of engine power for undetermined reasons.NTSB ERA09LA371Accident · 1 fatalLimited investigationFinal reportLayson Stanley B Steen SKY Bolt · High Point, NCThe pilot’s failure to maintain clearance from power lines during takeoff.NTSB CEN09LA385Accident · 1 fatalLimited investigationFinal reportSchendl Mustang II · West Union, OHThe pilot's failure to maintain adequate airspeed after a loss of engine power for undetermined reasons, which resulted in an aerodynamic stall/spin at a low altitude.NTSB WPR09LA299Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Saint Anthony, IDA total loss of engine power for undetermined reasons.NTSB ERA09LA316Accident · 2 fatalLimited investigationFinal reportRick Campbell Zenith-STOL CH801 · Gallman, MSA total loss of engine power due to fuel starvation as a result of the flightcrew's improper fuel management.NTSB ERA09CA313Accident · Minor injuriesData collectionFinal reportPensinger Zodiac 601 · Greeneville, TNAn encounter with wind shear on initial climb after takeoff.NTSB CEN09LA311Accident · 2 fatalLimited investigationFinal reportThornton RV-6A · Plainwell, MIThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CEN09IA294Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Houston, TXThe pilot's inadvertent application of excessive braking after touchdown, which caused the right wheels to lock and several tires to blow and resulted in a subsequent brake fire.