Final NTSB investigations, 2016

236 cases where the phase of flight was Enroute.

Cases per year

19622026
Final NTSB investigations, 2016 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\") = 2016
    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 CEN17LA066Accident · Serious injuriesLimited investigationFinal reportGosselin Charles Glastar · Lee's Summit, MOPartial failure of the electric system due to a battery short, which resulted in a total loss of engine power.Dec 31, 2016 · N120CG · Substantial damageNTSB CEN17FA064Accident · 4 fatalField investigationFinal reportPiper PA 28R-200 · Vienna, ILThe non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.Dec 31, 2016 · N2806R · DestroyedNTSB WPR17FA044Accident · 4 fatalField investigationFinal reportCessna 182 · Dabob, WAThe non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…Dec 30, 2016 · N52388 · Substantial damageNTSB WPR17LA050Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Kingman, AZThe loss of engine oil pressure during cruise flight, which resulted in partial loss of engine power and necessitated a forced landing. The loss of oil pressure was the result of a failed engine piston, likely initiated by foreign object damage, which…Dec 29, 2016 · N605SJ · Substantial damageNTSB ERA17FA073Accident · 3 fatalField investigationFinal reportCessna 182 · Gatlinburg, TNThe non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.Dec 26, 2016 · N1839X · DestroyedNTSB GAA17CA098Accident · Serious injuriesData collectionFinal reportCessna 182 · Apple Valley, CAThe pilot’s mismanagement of the available fuel, which resulted in a loss of engine power and a subsequent hard, off-airport landing and nose-over.Dec 19, 2016 · N5954B · Substantial damageNTSB ERA17LA071Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palm Bay, FLUnknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.Dec 19, 2016 · N150EC · Substantial damageNTSB CEN17LA058Accident · No injuriesLimited investigationFinal reportBellanca 17 30A · Blaine, MNA total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.Dec 18, 2016 · N4204B · Substantial damageNTSB OPS17IA010Incident · No injuriesIncident investigationFinal reportBoeing 777 · Mt. Wilson, CAThe incident was caused by the air traffic controller assigning the pilots a left turn instead of the required right turn after departure which placed the aircraft in an unsafe proximity with terrain and obstructions. Contributing to the incident was the air…Dec 16, 2016 · B-16726 · No damageNTSB ANC17FA012Accident · 2 fatalField investigationFinal reportPiper PA 11 · Aniak, AKThe pilot's intentional flight of the airplane into terrain in an act of suicide.Dec 16, 2016 · N5028H · Substantial damageNTSB DCA17CA042Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Denver, COAn inadvertent encounter with mountain wave turbulence.Dec 14, 2016 · N24202 · No damageNTSB WPR17LA036Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210M · Mecca, CAThe total loss of engine power due to fuel starvation during approach, which necessitated a gear-up landing on unsuitable terrain.Dec 12, 2016 · N761SZ · Substantial damageNTSB ERA17LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Shoreham, NYA fatigue crack of the crankshaft at the No. 4 main bearing journal.Dec 11, 2016 · N69286 · Substantial damageNTSB CEN17FA053Accident · 1 fatalField investigationFinal reportAircraft Mfg & Design CH601XL Slsa · Marengo, ILA loss of control in flight for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were identified during the investigation.Dec 10, 2016 · N4218 · DestroyedNTSB ANC17FA010Accident · 4 fatalField investigationFinal reportPiper PA 28-180 · Port Alsworth, AKUndetermined due to a lack of physical evidence.Dec 7, 2016 · N8648N · Substantial damageNTSB WPR17LA031Accident · No injuriesLimited investigationFinal reportPiper PA 31T · Missoula, MTFailure of the left windshield due to moisture ingression into the windshield laminate, which deteriorated the strength of the windshield.Dec 5, 2016 · N909PW · Substantial damageNTSB CEN17LA136Accident · No injuriesLimited investigationFinal reportCessna 550 · Port Aransas, TXAn in-flight collision with multiple birds, which resulted in separation of the right engine's fan rotor and subsequent total loss of power of the right engine.Dec 5, 2016 · N75WL · Substantial damageNTSB CEN17LA048Accident · No injuriesLimited investigationFinal reportArion Lightning LS-1 · Goshen, INA partial loss of engine power due to carburetor icing and the subsequent forced landing on a rough/soft field.Dec 3, 2016 · N218D · Substantial damageNTSB GAA17CA088Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA-20 · Payson, UTThe student pilot's improper in-flight fuel planning, which resulted in fuel exhaustion.Dec 2, 2016 · N992CT · Substantial damageNTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.Dec 2, 2016 · N129LZ · DestroyedNTSB ENG17IA006Incident · No injuriesIncident investigationFinal reportBombardier CL 600 2C10 · Kansas, ILThe probable cause of the uncontained No. 1 (left) engine failure was a separated high pressure turbine 2nd stage blade that failed due to a fatigue crack that originated below the blade platform from an area of corrosion.Nov 29, 2016 · N367CA · No damageNTSB ANC17LA008Accident · No injuriesLimited investigationFinal reportAirborne Extreme SQ-12 · Palmer, AKThe fuel injector manufacturer's inappropriate guidance to use a 5-ampere circuit breaker in place of the required 10-ampere circuit breaker on the fuel injector circuit, which resulted in the circuit breaker opening, a loss of electrical power to the…Nov 25, 2016 · N37PX · Substantial damageNTSB WPR17LA038Accident · No injuriesLimited investigationFinal reportCessna 182A · Safford, AZThe total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.Nov 24, 2016 · N6077B · Substantial damageNTSB WPR17FA025Accident · 1 fatalField investigationFinal reportPiper PA 28-181 · Upland, CAThe pilot's failure to maintain clearance from rising terrain in dark night conditions, which resulted in controlled flight into terrain.Nov 22, 2016 · N6912C · Substantial damageNTSB DCA17CA096Accident · Serious injuriesData collectionFinal reportBoeing 717 200 · Hopewell, VAthe flight attendant's inadvertent bump into a retractable galley tray.Nov 21, 2016 · N930AT · No damageNTSB ANC17LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · McGrath, AKThe failure of the nose landing gear to extend and lock due to the failure of the alternator and reduced battery power due to the cold ambient temperature, which prohibited the electrically-driven hydraulic pump from supplying adequate hydraulic pressure to…Nov 21, 2016 · N4352F · Minor damageNTSB ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.Nov 20, 2016 · N4976K · Substantial damageNTSB GAA17CA086Accident · Minor injuriesData collectionFinal reportBeech A36 · Ft. Myers, FLAn in-flight collision with a flock of birds.Nov 18, 2016 · N64793 · Substantial damageNTSB ERA17LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of torque on the No. 3 connecting rod’s nuts, which resulted in the failure of the No. 3 connecting rod’s bolts and a subsequent total loss of engine power due to the operator's maintenance personnel’s improper installation of the connecting rod nuts.Nov 13, 2016 · N94292 · Substantial damageNTSB CEN17LA039Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Pleasanton, TXMaintenance personnel's improper installation of the throttle linkage attachment hardware, which resulted in a partial loss of engine power when the hardware separated in flight.Nov 13, 2016 · N44C · Substantial damageNTSB WPR17LA018Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe pilot’s failure to ensure that sufficient fuel was available for the flight, which resulted in a total loss of engine power due to fuel exhaustion.Nov 10, 2016 · N9556U · Substantial damageNTSB ERA17LA045Accident · No injuriesLimited investigationFinal reportCessna 150 · Snow Hill, NCThe total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.Nov 10, 2016 · N23473 · Substantial damageNTSB ERA17LA041Accident · Serious injuriesLimited investigationFinal reportBeech 36 · Ormond Beach, FLA loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures of the flight controls that would have precluded normal operation.Nov 9, 2016 · N3089A · DestroyedNTSB ERA17LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Hopkinton, RIThe pilot's failure to accurately determine the airplane's fuel quantity before the flight, which resulted in a total loss of engine power due to fuel exhaustion.Nov 8, 2016 · N30703 · Substantial damageNTSB GAA17CA060Accident · No injuriesData collectionFinal reportCessna 172 · Englewood, COAn in-flight collision with multiple birds.Nov 7, 2016 · N6026Z · Substantial damageNTSB GAA17CA058Accident · No injuriesData collectionFinal reportBeech 58TC · Valdosta, GAThe pilot’s failure to ensure that adequate fuel was onboard for the flight, which resulted in fuel exhaustion and the loss of engine power.Nov 5, 2016 · N2CH · Substantial damageNTSB ERA17LA037Accident · No injuriesLimited investigationFinal reportAviat A 1B · Geneva, FLA partial loss of engine power due to debris in the No. 1 cylinder that damaged the spark plugs.Nov 2, 2016 · N54HY · Substantial damageNTSB ANC17FA004Accident · 1 fatalField investigationFinal reportFairchild Heli-Porter Pilatus PC-6 · Port Alsworth, AKThe airplane's collision with mountainous terrain while operating in an area of reduced visibility and icing conditions. Contributing to the accident was the pilot's inadequate preflight planning, which would have identified deteriorating weather conditions…Oct 29, 2016 · N5308F · Substantial damageNTSB CEN17LA030Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bloomfield, NMMaintenance personnel’s failure to fully torque the fuel port cap, which allowed the cap to back off in flight and interrupted fuel flow to the engine, which resulted in a total loss of engine power.Oct 28, 2016 · N234PJ · Substantial damageNTSB WPR17FA013Accident · 2 fatalField investigationFinal reportBeech A36 · Pittsburg, CAA loss of airplane control for reasons that could not be determined due to the extensive impact and fire damage to the airplane.Oct 25, 2016 · N364RM · DestroyedNTSB WPR17LA011Accident · No injuriesLimited investigationFinal reportMooney M20J · Coalinga, CAA partial loss of engine power due to the pilot's improper in-flight fuel management, which resulted in fuel starvation.Oct 23, 2016 · N201EU · Substantial damageNTSB WPR17LA012Accident · Minor injuriesLimited investigationFinal reportNorthland IVP · Lovelock, NVA total loss of engine power due to the failure of the intake valve in the No. 3 cylinder for reasons that could not be determined based on the available information.Oct 20, 2016 · N4YB · Substantial damageNTSB GAA17CA036Accident · No injuriesData collectionFinal reportCessna 172 · Carrabassett, METhe pilot’s failure to maintain clearance from trees while maneuvering at a low altitude.Oct 20, 2016 · N1706F · Substantial damageNTSB GAA17CA032Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Carrollton, GAThe pilot's failure to verify the usable fuel in the fuel tanks, which resulted in an inaccurate fuel totalizer setting during preflight, fuel exhaustion, and a total loss of engine power.Oct 20, 2016 · N601UK · Substantial damageNTSB ERA17LA023Accident · Serious injuriesLimited investigationFinal reportErcoupe 415 · Lindenwold, NJA partial loss of engine power for reasons that could not be determined based on the available information.Oct 19, 2016 · N415WE · Substantial damageNTSB ERA17FA017Accident · 3 fatalField investigationFinal reportPiper PA28 · Austin, PAThe pilot's loss of control while maneuvering in night instrument conditions that included light-to-heavy rain with severe turbulence, updrafts and downdrafts, and hail. Contributing to the accident was the pilot experiencing spatial disorientation, his lack…Oct 16, 2016 · C-GYSN · DestroyedNTSB CEN17LA019Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Mc Alester, OKA total loss of engine power during initial climb due to fuel starvation.Oct 16, 2016 · N93668 · Substantial damageNTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…Oct 15, 2016 · N8718X · DestroyedNTSB ERA17LA016Accident · Serious injuriesLimited investigationFinal reportHatcher Roderick R CH701 · Albrightsville, PAA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.Oct 15, 2016 · N3701M · Substantial damageNTSB CEN17LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Jasper, TXA partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power.Oct 15, 2016 · N9473D · Substantial damage