Fatal NTSB investigations

225 cases where the sequence of events included Off-field or emergency landing.

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\" = '440' 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 ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.Apr 14, 2012 · N235MW · Substantial damageNTSB CEN12FA210Accident · 1 fatalField investigationFinal reportBeech E-55 · Broken Bow, NEThe pilot’s failure to maintain airspeed and subsequent loss of airplane control during a single-engine landing approach. Contributing to the accident was the pilot's improper fuel management during cruise flight, which resulted in an initial loss of power in…Mar 28, 2012 · N1567W · Substantial damageNTSB CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.Mar 23, 2012 · N10468 · 2 aircraft · Substantial damageNTSB DCA12PA049Accident · 1 fatalFinal reportIsrael Aircraft Industries F21-C2 · Fallon, NVfuel exhaustion following missed approaches due to deficient ATC handling under weather conditions which were significantly lower than forecast. The second missed approach may have been initiated due to limited pilot instrument proficiency. Contributing to…Mar 6, 2012 · N404AX · DestroyedNTSB 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 WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.Dec 8, 2011 · N2611R · Substantial damageNTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.Nov 30, 2011 · N6485L · Minor damageNTSB ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.Nov 26, 2011 · N5AW · Substantial damageNTSB ERA12FA021Accident · 1 fatalField investigationFinal reportElkind Bruce Cozy MK IV · Lexington, NCThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Oct 23, 2011 · N795DB · Substantial damageNTSB ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.Oct 8, 2011 · N41907 · Substantial damageNTSB ERA11FA512Accident · 1 fatalField investigationFinal reportHeronimus Kevin A Glasair III · Falls of Rough, KYThe failure of the propeller power speed reduction unit, which resulted in a loss of engine power at low altitude.Sep 30, 2011 · N43KH · Substantial damageNTSB ERA11LA503Accident · 1 fatalLimited investigationFinal reportCessna 120 · Cordele, GAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Sep 24, 2011 · N3101N · Substantial damageNTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.Sep 2, 2011 · N207DR · 2 aircraft · DestroyedNTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…Aug 17, 2011 · N444YM · Substantial damageNTSB CEN11LA573Accident · 1 fatalLimited investigationFinal reportStevens R P/Mccright D W Vans RV-6 · Conroe, TXThe failure of the pilot of the RV-6 airplane to maintain clearance from the RV-8 airplane while practicing formation flight.Aug 13, 2011 · N16DD · 2 aircraft · Substantial damageNTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.Jul 26, 2011 · N41MK · Substantial damageNTSB ERA11FA414Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Palm Bay, FLThe pilot’s failure to maintain adequate airspeed while maneuvering for a forced landing, resulting in an inadvertent aerodynamic stall. Contributing to the accident were the pilot’s failure to secure the oil gauge rod and cap assembly before flight and his…Jul 23, 2011 · N122HB · Substantial damageNTSB ERA11FA374Accident · 1 fatalField investigationFinal reportBinkley Richard Sonex · Calhoun, GAThe total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.Jul 2, 2011 · N6PX · Substantial damageNTSB ERA11FA334Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Westbrook, CTA total loss of engine power during approach due to inadequate torque on the No. 3 cylinder hold-down nuts.Jun 10, 2011 · N8233P · Substantial damageNTSB CEN11FA358Accident · 2 fatalField investigationFinal reportRockwell 112 · Bryan, TXThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…May 29, 2011 · N1041J · Substantial damageNTSB ERA11FA285Accident · 2 fatalField investigationFinal reportHebert Peter J Lancair Legacy · Richlands, NCThe pilot's improper in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.May 6, 2011 · N23PH · Substantial damageNTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.Mar 25, 2011 · N7746K · Substantial damageNTSB WPR11FA120Accident · 1 fatalField investigationFinal reportAeronca O-58C · San Luis Obispo, CAThe pilot’s delay in using carburetor heat, which resulted in a loss of engine power due to an encounter with carburetor icing conditions.Feb 3, 2011 · N47503 · Substantial damageNTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.Dec 5, 2010 · N9742Z · Substantial damageNTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Nov 22, 2010 · N6064N · Substantial damageNTSB ERA11LA050Accident · 1 fatalLimited investigationFinal reportNorth American/Schwamm AT-6F · Fitchburg, MAA total loss of engine power due to a cracked carburetor float and resulting carburetor malfunction.Nov 6, 2010 · N164US · Substantial damageNTSB CEN11FA029Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Sebewaing, MIThe pilot's failure to maintain airspeed and aircraft control following a loss of engine power after takeoff.Oct 18, 2010 · N105AC · Substantial damageNTSB ERA11FA021Accident · 1 fatalField investigationFinal reportSiai-Marchetti S.205/22R · Farmingdale, NYA loss of engine power during a low approach for undetermined reasons.Oct 17, 2010 · N934W · Substantial damageNTSB ERA11LA014Accident · 1 fatalLimited investigationFinal reportEngineering & Research Ercoupe 415-D · Lawrenceville, GAInadequate maintenance performed on the airplane, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the corrosion within the carburetor.Oct 9, 2010 · N89331 · Substantial damageNTSB WPR11LA004Accident · 1 fatalLimited investigationFinal reportBeech A35 · Blue Diamond, NVThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Oct 8, 2010 · N8402A · Substantial damageNTSB ERA10FA502Accident · 2 fatalField investigationFinal reportCessna 172 · Chatsworth, GAThe pilot's inadequate flight planning and in-flight fuel management resulting in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the operator's failure to ensure aircraft records pertaining to engine modifications and…Sep 25, 2010 · N84249 · Substantial damageNTSB ERA10FA409Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Washington, GAThe manufacturer's inadequate quality control and improper manufacture of the fuel servo diaphragm assembly, which resulted in fatigue cracking of the hub stud and subsequent loss of engine power due to fuel starvation.Aug 10, 2010 · N220ST · Substantial damageNTSB WPR10LA381Accident · 2 fatalLimited investigationFinal reportAdvertising Mgmt & Consulting Velocity Super XLRG5 · San Diego, CAThe pilot did not close and secure the right passenger door, which resulted in an in-flight separation of the door and subsequent loss of engine power due to the door’s collision with the rear-mounted engine assembly.Aug 2, 2010 · N444YP · Substantial damageNTSB WPR10FA371Accident · 3 fatalField investigationFinal reportAmerican Eurocopter AS 350 B3 · Tucson, AZThe repair station technician did not properly install the fuel inlet union during reassembly of the engine; the operator’s maintenance personnel did not adequately inspect the technician's work; and the pilot who performed the post maintenance check flight…Jul 28, 2010 · N509AM · Substantial damageNTSB ERA10LA373Accident · 2 fatalLimited investigationFinal reportNadig Paul K Nadig · Franklin, PAA partial loss of engine power due to the owner’s inadequate fuel system maintenance, which resulted in a collision with trees and subsequent impact with the ground.Jul 24, 2010 · N579PN · Substantial damageNTSB WPR10LA356Accident · 1 fatalLimited investigationFinal reportParker RS-15 Sailplane · Marysvale, UTThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.Jul 17, 2010 · N15LQ · Substantial damageNTSB ERA10WA371Accident · 1 fatalForeign investigationRobinson R44 · Novo Horizonte, BrazilOn July 16, 2010, about 1645 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Brazilian registration PR-TNB, operated by Pereira Alvim Participacoes e Empreendimentos Ltda, was destroyed by fire after landing in a cane field at Novo Horizonte,…Jul 16, 2010 · PR-TNB · DestroyedNTSB CEN10LA368Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Pocahontas, ILThe pilot's failure to maintain a wings-level attitude prior to impacting high vegetation and terrain during the off-field landing.Jul 4, 2010 · N82BK · Substantial damageNTSB ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…Jun 21, 2010 · N30266 · Substantial damageNTSB ERA10WA338Accident · 2 fatalForeign investigationBolkow BO105 · Buenos Aires, ArgentinaOn June 18, 2010, about 1118 universal Coordinated Time (UTC),an Bolkow BO-105, Argentina registration LV-WJX, operated by a private owner on a business flight, to photograph a automobile accident, collided with tall trees, overhead power lines, and struck…Jun 18, 2010 · LV-WJX · DestroyedNTSB ERA10FA283Accident · 1 fatalField investigationFinal reportSchweizer 269C-1 · Boxborough, MAThe FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…May 26, 2010 · N73SJ · Substantial damageNTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.Apr 3, 2010 · N5528T · Substantial damageNTSB ERA10LA203Accident · 1 fatalLimited investigationFinal reportLopez Phillip Jabiru J250 · Middletown, DEThe pilot's failure to apply carburetor heat, which resulted in the formation of carburetor icing and a total loss of engine power.Apr 2, 2010 · N464PP · Substantial damageNTSB CEN10FA180Accident · 2 fatalField investigationFinal reportBeech B36TC · Dayton, OHThe complete loss of engine power due to failure of the No. 1 main bearing, and the secondary failure of a crankcase through-bolt and the fuel pump drive coupling. Contributing to the accident was the pilot's decision to attempt a return to the airport for a…Apr 1, 2010 · N4BA · DestroyedNTSB ERA10LA175Accident · 1 fatalLimited investigationFinal reportSmith Edward I Lancair IV-P · Hilton Head Island, SCA loss of engine power due to the failure of the crankshaft as a result of a previous propeller strike.Mar 15, 2010 · N9JE · Minor damageNTSB WPR10FA158Accident · 1 fatalField investigationFinal reportBeech K35 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management; also causal was his subsequent failure to maintain clearance from power lines.Mar 13, 2010 · N5392E · Substantial damageNTSB ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.Feb 8, 2010 · N130SP · Substantial damageNTSB 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 ERA10LA086Accident · 2 fatalLimited investigationFinal reportCox Busby Mustang · Plant City, FLThe pilot’s failure to maintain adequate airspeed following a loss of engine power for undetermined reasons.Nov 29, 2009 · N72PC · Substantial damageNTSB ERA10FA074Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Wappinger, NYA total loss of engine power due to a delamination of the No. 3 connecting rod bearing. Contributing to the accident was the inadequate maintenance inspection of the engine oil system.Nov 22, 2009 · N345AT · Substantial damage