Fatal NTSB investigations

215 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.\"highestInjuryLevel\" = 'Fatal'
    AND 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.

NTSB ERA12FA175Accident · 1 fatalField investigationFinal reportCessna T182T · Lebanon, NHThe pilot’s failure to maintain airspeed during a return to the airport after takeoff, which resulted in an aerodynamic stall and loss of airplane control.Feb 9, 2012 · N6062E · Substantial damageNTSB ERA12FA146Accident · 1 fatalField investigationFinal reportAerostar PA-60-601P · Philadelphia, MSThe pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…Jan 16, 2012 · N700PS · Substantial damageNTSB DCA12FA024Accident · 3 fatalField investigationFinal reportBell 214 · Camp Bastion, Afghanistanthe overtravel of the collective sleeve, which led to a severe and sudden reduction in main rotor blade collective pitch, resulting in a loss of control of the helicopter. The reason for the collective sleeve overtravel could not be determined since much of…Jan 16, 2012 · N5748M · DestroyedNTSB ERA12LA141Accident · 1 fatalLimited investigationFinal reportBowers Fly Baby 1-A · Jefferson, GAThe pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…Jan 8, 2012 · N4626 · DestroyedNTSB CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.Nov 10, 2011 · N337LC · DestroyedNTSB CEN11FA444Accident · 1 fatalField investigationFinal reportBoeing B75N1 · Wetmore, COThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.Jul 3, 2011 · N4473N · Substantial damageNTSB ERA11FA354Accident · 2 fatalField investigationFinal reportBeech C24R · Valparaiso, FLThe pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.Jun 23, 2011 · N38029 · Substantial damageNTSB 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.May 25, 2011 · N77AR · Substantial damageNTSB CEN11FA346Accident · 1 fatalField investigationFinal reportHansen IB C Cassutt III M · Erie, COThe pilot's incapacitation due to a cardiac event.May 22, 2011 · N420FH · Substantial damageNTSB 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…Apr 2, 2011 · N652GD · Substantial damageNTSB 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.Mar 29, 2011 · N619VH · Substantial damageNTSB ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyDec 8, 2010 · N58SE · DestroyedNTSB 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.Nov 18, 2010 · N314DP · Substantial damageNTSB 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.Oct 6, 2010 · N9695U · Substantial damageNTSB 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…Sep 30, 2010 · PR-CCO · DestroyedNTSB 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.Sep 19, 2010 · UNREG · Substantial damageNTSB CEN10LA442Accident · 1 fatalLimited investigationFinal reportLunceford Sparrowhawk II · Tell City, INThe pilot's loss of control of the gyroplane for undetermined reasons.Jul 27, 2010 · N91814 · Substantial damageNTSB 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.Jun 2, 2010 · N515MK · Substantial damageNTSB ERA10FA178Accident · 1 fatalField investigationFinal reportBeech 95 · Lagrange, NYThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.Mar 18, 2010 · N9389Y · Substantial damageNTSB CEN10FA130Accident · 2 fatalField investigationFinal reportBeech C24R · Bristow, OKThe pilot’s loss of control for undetermined reasons while maneuvering at low altitude.Feb 28, 2010 · N63713 · DestroyedNTSB 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.Dec 25, 2009 · N499CM · DestroyedNTSB 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.Dec 9, 2009 · N1105N · DestroyedNTSB 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.Nov 15, 2009 · N1723T · Substantial damageNTSB 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.Nov 7, 2009 · N651WA · DestroyedNTSB CEN10LA034Accident · 2 fatalLimited investigationFinal reportPiper PA-18-135 · Sikeston, MOThe pilot's failure to maintain directional control during a crosswind takeoff.Oct 31, 2009 · N1198C · Substantial damageNTSB 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.Oct 23, 2009 · N6025U · Substantial damageNTSB 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.Oct 18, 2009 · N7906W · Substantial damageNTSB 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.Sep 24, 2009 · N9734Y · DestroyedNTSB 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…Sep 20, 2009 · N2467Y · Substantial damageNTSB CEN09LA538Accident · 2 fatalLimited investigationFinal reportBrown Joseph B JR RV-6 · Ama, LAThe pilot’s failure to maintain directional control during takeoff.Aug 23, 2009 · N352JB · Substantial damageNTSB 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.Aug 10, 2009 · N112PM · Substantial damageNTSB ERA09LA371Accident · 1 fatalLimited investigationFinal reportLayson Stanley B Steen SKY Bolt · High Point, NCThe pilot’s failure to maintain clearance from power lines during takeoff.Jun 27, 2009 · N233VW · Substantial damageNTSB 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.Jun 25, 2009 · N152AS · Substantial damageNTSB 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.Jun 2, 2009 · N1399X · Substantial damageNTSB CEN09LA311Accident · 2 fatalLimited investigationFinal reportThornton RV-6A · Plainwell, MIThe pilot's failure to maintain aircraft control for undetermined reasons.May 21, 2009 · N39JT · DestroyedNTSB CEN09FA243Accident · 2 fatalField investigationFinal reportEngineering and Research 415C · Sandwich, ILThe pilot's failure to execute an immediate forced landing to a suitable field and the engine's partial loss of power for an undetermined reason.Apr 11, 2009 · N87384 · DestroyedNTSB CEN09WA216Accident · 3 fatalForeign investigationRobinson R44 · Tocumen, PanamaThe investigation is under the jurisdiction of the government of Panama. Further information pertaining to this accident may be obtained from: Direccion de Aeronautica Civil Apartados 7501 y 7615 Panama 5 http://www.aeronautica.gob.pa This report is for…Feb 19, 2009 · HP-AM3 · DestroyedNTSB CEN09FA115Accident · 2 fatalField investigationFinal reportNanchang China CJ-6 · Justin, TXThe pilot's failure to maintain adequate airspeed while maneuvering on approach, which resulted in an accelerated stall and subsequent loss of control.Jan 3, 2009 · N99YK · DestroyedNTSB CEN09FA111Accident · 2 fatalField investigationFinal reportLantzair Flyers Lancair 360 · Joliet, ILThe pilot’s failure to maintain adequate flying speed during the night takeoff for undetermined reasons, which resulted in an inadvertent aerodynamic stall and subsequent loss of controlJan 2, 2009 · N3603R · DestroyedNTSB CEN09LA054Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Mena, ARThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's continued flight into deteriorating weather conditions.Nov 11, 2008 · N2526V · Substantial damageNTSB CEN09FA043Accident · 1 fatalField investigationFinal reportCessna 175 · Mt. Dora, NMThe pilot's failure to maintain clearance from rising terrain for undetermined reasons.Oct 29, 2008 · N175JG · DestroyedNTSB CEN09FA015Accident · 1 fatalField investigationFinal reportCessna 150G · Cedar Lake, MIThe student pilot's failure to maintain adequate clearance after takeoff. Contributing to the accident was the pilot's overall lack of flight experience.Oct 11, 2008 · N3623J · Substantial damageNTSB CEN09LA009Accident · 1 fatalLimited investigationFinal reportSproul 72K-TET · Rio Rancho, NMThe pilot's failure to maintain clearance from the power lines and the failure of either pilot to take any corrective action to avoid the collision.Oct 10, 2008 · N72KX · DestroyedNTSB CHI08FA293Accident · 2 fatalField investigationFinal reportRobinson R44 II · Kenosha, WIThe pilots failure to maintain clearance from terrain resulting in an in-flight collision with a house. Contributing to the accident was the night instrument meteorological conditions (IMC) and the pilot's lack of experience of flying in IMC.Sep 21, 2008 · N999ZD · DestroyedNTSB DCA08MA098Accident · 4 fatalClass 1 · MajorFinal reportLearjet LR60 · Columbia, SCThe operator’s inadequate maintenance of the airplane’s tires, which resulted in multiple tire failures during takeoff roll due to severe underinflation, and the captain’s execution of a rejected takeoff (RTO) after V1, which was inconsistent with her…Sep 20, 2008 · N999LJ · DestroyedNTSB ANC08LA122Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain sufficient airspeed to preclude a stall while maneuvering at a low altitude, resulting in an uncontrolled descent and collision with terrain.Sep 11, 2008 · N7174K · Substantial damageNTSB NYC08FA307Accident · 1 fatalField investigationFinal reportLindstrand Balloons 150A · Phoenixville, PAThe separation of a portion of a fuel fitting during a hard landing resulting in release of fuel and a fire in the balloons basket area. Contributing to the accident was the pilot's failure to follow the manufacturer's published procedures to shut down the…Sep 7, 2008 · N844LB · Substantial damageNTSB DFW08FA218Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ridgedale, MOAn in-flight loss of control for undetermined reasons.Aug 29, 2008 · N41411 · DestroyedNTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.Aug 24, 2008 · N5476P · Substantial damageNTSB SEA08FA187Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Springerville, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.Aug 20, 2008 · N5316L · Substantial damage