Final NTSB investigations, 2017

200 cases where the phase of flight was Enroute.

Cases per year

19622026
Final NTSB investigations, 2017 per year, 1962–2026: 34,146 cases
196218
196328
1964703
1965750
1966856
1967893
1968881
1969995
1970996
1971941
1972894
1973935
1974968
1975977
1976927
1977936
19781,018
1979968
1980873
1981881
1982786
1983734
1984747
1985704
1986693
1987616
1988656
1989590
1990548
1991574
1992542
1993533
1994498
1995506
1996511
1997466
1998467
1999452
2000451
2001396
2002407
2003415
2004380
2005390
2006325
2007353
2008248
2009285
2010240
2011250
2012259
2013225
2014210
2015228
2016236
2017200
2018243
2019227
2020177
2021205
2022206
2023210
2024203
202581
202635

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 year(c.\"eventDate\") = 2017
    AND c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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 WPR18LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 150L · Perris, CAThe presence of debris in the carburetor and blockage of the fuel delivery system, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the lack of maintenance to the carburetor.Dec 25, 2017 · N6627G · Substantial damageNTSB ERA18FA056Accident · 1 fatalField investigationFinal reportBeech G35 · Cross City, FLThe pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control.Dec 21, 2017 · N354WD · DestroyedNTSB DCA18CA049Accident · Serious injuriesData collectionFinal reportEmbraer S A ERJ170-200LR · Saint Louis, MOthe abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle.Dec 18, 2017 · N128SY · No damageNTSB CEN18FA054Accident · 2 fatalField investigationFinal reportPiper PA28 · Reeds Spring, MOThe noninstrument-rated pilot's inadequate pre-flight planning and in-flight decision-making, which resulted in flight into known instrument meteorological conditions and the subsequent collision with terrain.Dec 18, 2017 · N6433J · DestroyedNTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…Dec 17, 2017 · N761YZ · DestroyedNTSB ERA18LA055Accident · No injuriesLimited investigationFinal reportCessna 182 · Burlington, NCThe pilot's failure to maintain adequate clearance from another airplane before beginning an inverted flight maneuver, which resulted in a collision with the airplane when he rolled his airplane upright.Dec 16, 2017 · N199RN · 2 aircraft · Substantial damageNTSB ERA18LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLThe loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power.Dec 16, 2017 · N95550 · Substantial damageNTSB WPR18FA046Accident · 2 fatalField investigationFinal reportBeech A36 · San Diego, CAA total loss of engine power for reasons that could not be determined based on the available information.Dec 10, 2017 · N248SB · DestroyedNTSB DCA18CA055Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Fort Lauderdale, FLan inadvertent encounter with convective turbulence that resulted in a flight attendant injury.Dec 6, 2017 · N670NK · No damageNTSB ERA18LA041Accident · No injuriesLimited investigationFinal reportPiper PA28 · Brewton, ALThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 5, 2017 · N747KM · Substantial damageNTSB WPR18LA043Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Rio Oso, CAAn in-flight fire due to electrical arc corrosion of the fuel line.Dec 4, 2017 · N251E · Substantial damageNTSB CEN18LA042Accident · No injuriesLimited investigationFinal reportMotley Gary W Zenith CH750 Cruzer · Louviers, COThe engine’s excessive cylinder head temperatures and the subsequent seizing of the engine, which resulted from an engine control unit that caused the engine’s fuel-air mixture to be too lean.Nov 27, 2017 · N956GM · Substantial damageNTSB CEN18LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Midland, TXThe improper installation of the generator by unknown personnel, which resulted in a loss of oil and subsequent engine failure.Nov 26, 2017 · N8637S · Substantial damageNTSB WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.Nov 25, 2017 · N57351 · Substantial damageNTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).Nov 25, 2017 · N739KW · Substantial damageNTSB CEN18FA037Accident · 1 fatalField investigationFinal reportCessna 172G · Pittsford, VTThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.Nov 22, 2017 · N4676L · DestroyedNTSB CEN18FA033Accident · 3 fatalField investigationFinal reportBell Helicopter Textron Canada 407 · Stuttgart, ARAn in-flight loss of control due to bird strikes.Nov 20, 2017 · N620PA · DestroyedNTSB GAA18CA048Accident · Minor injuriesData collectionFinal reportCessna 172M · Chico, CAAn in-flight collision with a bird.Nov 19, 2017 · N9678Q · Substantial damageNTSB WPR18LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28R-201T · Nipton, CAA loss of engine power due to the detonation of the No. 5 cylinder due to excessive leaning at high power settings, which resulted in a forced landing and the subsequent hard touchdown.Nov 17, 2017 · N5966V · Substantial damageNTSB ERA18FA022Accident · 4 fatalField investigationFinal reportPiper PA32 · Fountain Run, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete…Nov 12, 2017 · N3371W · DestroyedNTSB ANC18LA008Accident · No injuriesLimited investigationFinal reportCloud Jeffrey Ferrell Long EZ · Eufaula, ALThe in-flight separation of a portion of the propeller, which subsequently penetrated the right rudder, as a result of the failure of the bond line between two of the propeller’s wood layers. Contributing to the failure of the propeller was the manufacturer’s…Nov 11, 2017 · N754T · Substantial damageNTSB WPR18LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Redding, CAThe fatigue separation of the crankshaft due to a fatigue fracture, which resulted in a total loss of engine power and a subsequent off-airport landing and impact with a fence.Nov 2, 2017 · N2103T · Substantial damageNTSB WPR18LA021Accident · No injuriesLimited investigationFinal reportMetcalfe Robert B Vans RV 6 · Selma, CAThe pilot’s failure to properly secure an alternator ground cable swage that led to problems with the electrical system and/or electronic engine controls, which resulted in a total loss of engine power.Oct 30, 2017 · N88MV · Substantial damageNTSB ANC18LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · Dawsonville, GAThe failure of the pilot, who was not a certified mechanic, to tighten the B-nut on a remotely mounted oil filter line, which resulted in oil exhaustion, a total loss of oil pressure, and a subsequent total loss of engine power.Oct 30, 2017 · N4213F · Substantial damageNTSB WPR18FA011Accident · 1 fatalField investigationFinal reportPeterson Lancair Legacy · Bowie, AZAn in-flight loss of control due to a bird strike.Oct 19, 2017 · N259L · Substantial damageNTSB ERA18LA011Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 402 · St. Petersburg, FLThe pilot's mismanagement of the onboard fuel, which resulted in fuel starvation, a total loss of power to both engines, and a subsequent forced landing.Oct 18, 2017 · N900CR · Substantial damageNTSB WPR18LA010Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R44 · Molokai, HIA descent and subsequent impact with open ocean waters for reasons that could not be determined based on the available information.Oct 17, 2017 · N820DF · DestroyedNTSB ANC18FA003Accident · 1 fatalField investigationFinal reportCessna 210 · Russian Mission, AKThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.Oct 16, 2017 · N8347Z · DestroyedNTSB DCA18CA007Accident · Serious injuriesData collectionFinal reportBoeing 767 328 · Honolulu, HIan inadvertent encounter of clear air turbulence.Oct 15, 2017 · N342AX · No damageNTSB CEN18LA013Accident · No injuriesLimited investigationFinal reportRussell E Oberg Murphy Rebel · Fort Collins, COA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat.Oct 12, 2017 · N734R · Substantial damageNTSB WPR18LA006Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ 6 · Buckeye, AZThe failure of the fuel pump’s diaphragm which resulted in fuel system contamination from air and or oil and caused the engine to lose power.Oct 9, 2017 · N8NW · Substantial damageNTSB WPR18LA018Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Blythe, CAMaintenance personnel's failure to properly torque an oil supply line fitting, which resulted in oil starvation, a subsequent engine failure, and an off-airport landing.Oct 3, 2017 · N418CP · Substantial damageNTSB WPR18LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Tonopah, NVThe pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of…Oct 2, 2017 · N5311H · Substantial damageNTSB WPR18FA001Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Klamath Falls, ORThe noninstrument rated pilot's decision to depart on a cross-country flight with en route weather conditions forecasted to be less than visual meteorological conditions and then to continue flight into instrument meteorological conditions, which resulted in…Oct 1, 2017 · N6083D · DestroyedNTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…Sep 30, 2017 · N9549W · DestroyedNTSB CEN17CA371Accident · No injuriesData collectionFinal reportVans RV7 · Itasca, TXThe pilot’s inadequate preflight planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Sep 29, 2017 · N712RL · Substantial damageNTSB ERA17FA339Accident · 1 fatalField investigationFinal reportHickox Andy Andys Gyroplane · Umatilla, FLThe pilot's improper response to a total loss of engine power, which resulted in main rotor blade contact with the rudder and vertical stabilizer, and a subsequent uncontrolled descent. The loss of engine power was due to the separation of the electrical…Sep 28, 2017 · N152AH · DestroyedNTSB WPR17LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · TamuningThe pilot's inadequate preflight inspection, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.Sep 25, 2017 · N5448K · Substantial damageNTSB ERA17LA335Accident · Minor injuriesClass 3 · LimitedFinal reportBrad J Bates Mosquito XE 285 · Odessa, FLA total loss of engine power due to cold seizure of the No.1 piston, which resulted in its failure and a subsequent emergency autorotation and impact with a house’s roof.Sep 25, 2017 · N926KB · Substantial damageNTSB DCA17CA217Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Sioux City, IAthe flight attendant accidentally pouring hot water on his hand which resulted in a 2nd degree burn.Sep 25, 2017 · N500WR · No damageNTSB WPR17LA212Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glendale, CAThe pilot’s inadequate preflight fuel planning and improper decision to not refuel before the flight, which resulted in fuel exhaustion and the subsequent total loss of engine power.Sep 23, 2017 · N34BE · Substantial damageNTSB DCA17IA202Incident · No injuriesIncident investigationFinal reportDJI Phantom · Hoffman Island, NYthe failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.Sep 21, 2017 · UNREG · 2 aircraft · DestroyedNTSB CEN17LA358Accident · No injuriesLimited investigationFinal reportCessna 177B · London, OHThe flight instructor's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Sep 17, 2017 · N35170 · Substantial damageNTSB ERA17LA347Accident · No injuriesLimited investigationFinal reportBeech 35 · Marathon, FLA total loss of engine power for reasons that could not be determined because saltwater corrosion precluded a complete examination.Sep 16, 2017 · N3187V · Substantial damageNTSB ERA17FA327Accident · 2 fatalField investigationFinal reportMooney M20C · North Branford, CTA total loss of engine power due to fuel starvation as the result of foreign object debris in the fuel selector valve. Contributing to the accident was the pilot's selection of a low cruising altitude, which reduced the available time to troubleshoot the loss…Sep 16, 2017 · N53CP · Substantial damageNTSB CEN17FA355Accident · 1 fatalField investigationFinal reportBell 206L 3 · Ancho, NMThe pilot's distraction by a cell phone during a low-altitude flight, which resulted in controlled flight into terrain.Sep 16, 2017 · N213TV · DestroyedNTSB ERA17LA338Accident · No injuriesLimited investigationFinal reportParks Richard A Starduster SA 100 · Southfields, NYA loose oil line that allowed oil to drip on the exhaust system, which resulted in smoke during cruise flight and a subsequent precautionary landing.Sep 15, 2017 · N1356W · Substantial damageNTSB ERA17LA326Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502 · Union City, TNThe catastrophic failure of the compressor turbine blades, which resulted in a total loss of engine power. Contributing to the accident was the installation of undocumented, time-limited engine components of indeterminate age.Sep 15, 2017 · N4531K · Substantial damageNTSB CEN17LA352Accident · No injuriesLimited investigationFinal reportCessna 210G · Hallsville, MOThe total loss of engine power due to a fatigue failure of the engine mixture control cable.Sep 13, 2017 · N5906F · Substantial damageNTSB CEN17LA356Accident · No injuriesLimited investigationFinal reportCessna R182 · Worland, WYThe pilot's decision to operate an airplane with unreliable fuel gauges and the worn fuel cap seal that allowed fuel to siphon from the left wing fuel tank, which ultimately resulted in a total loss of engine power due to fuel exhaustion.Sep 12, 2017 · N1835R · Substantial damage