NTSB investigations, 2016, FL

20 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2016, FL per year, 1962–2026: 2,183 cases
19621
19632
196426
196530
196635
196737
196845
196933
197053
197142
197243
197361
197438
197550
197639
197751
197855
197954
198058
198155
198254
198352
198459
198558
198664
198746
198841
198937
199037
199138
199237
199335
199440
199543
199638
199735
199831
199942
200025
200125
200231
200333
200431
200535
200622
200739
200819
200929
201018
201113
201222
201317
201413
201513
201620
201718
201822
201914
202012
202123
202216
202315
202424
202520
202619

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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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 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 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 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 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 ERA17LA018Accident · 1 fatalLimited investigationFinal reportCessna 208 · Dunnellon, FLThe jumpmaster's failure to guard the reserve parachute ripcord, which caused an inadvertent deployment of his reserve parachute.Oct 14, 2016 · N208KM · Substantial damageNTSB GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.Oct 10, 2016 · N399DC · Substantial damageNTSB ERA16FA309Accident · 2 fatalField investigationFinal reportCessna 172 · Hollywood, FLThe pilot's inadequate preflight and in-flight weather planning, which resulted in continued flight into a thunderstorm and a subsequent loss of airplane control.Sep 3, 2016 · N6091E · DestroyedNTSB DCA16FA217Accident · No injuriesField investigationFinal reportBoeing 737-700 · Pensacola, FLA low-cycle fatigue crack in the dovetail of fan blade No. 23, which resulted in the fan blade separating in flight and impacting the fan case. This impact caused the fan blade to fracture into fragments that traveled farther than expected into the inlet,…Aug 27, 2016 · N766SW · Substantial damageNTSB ERA16FA297Accident · 1 fatalField investigationFinal reportHeberlein Ronald Vans RV 9A · Sebring, FLThe pilot's failure to maintain clearance from terrain.Aug 24, 2016 · N379RV · DestroyedNTSB ERA16LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA32 · Windermere, FLA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.Jul 8, 2016 · N1495J · Substantial damageNTSB ERA16FA238Accident · 1 fatalField investigationFinal reportGerdts Mark E RV7A · Weston, FLThe pilot's loss of airplane control for reasons that could not be determined based on the available evidence.Jul 3, 2016 · N1075F · DestroyedNTSB ERA16LA193Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Melrose, FLA total loss of engine power due to fuel exhaustion.May 23, 2016 · N952SA · Substantial damageNTSB ERA16LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Okeechobee, FLThe failure of the No. 3 piston due to fatigue cracking, which resulted in a total loss of engine power and subsequent forced landing, during which the airplane impacted obstacles.Apr 18, 2016 · N151DC · Substantial damageNTSB OPS16IA010IncidentClass 3 · IncidentFinal reportMooney M20R · Jacksonville, FLThe air traffic controller's decision to issue climb instruction to one aircraft without ensuring the required separation with another could be maintained. Contributing to the incident was the air traffic controller's failure to issue a safety alert in a…Apr 3, 2016 · N57GX · 2 aircraft · No damageNTSB ERA16FA127Accident · 2 fatalField investigationFinal reportSheahen Dane E RV-8 · Clermont, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…Mar 12, 2016 · N838RV · Substantial damageNTSB ERA16LA123Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BL · St. Petersburg, FLA partial loss of engine power due to the fatigue fracture of the No. 3 cylinder head stud.Mar 5, 2016 · N22661 · Substantial damageNTSB ERA16LA110Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Palatka, FLA partial loss of engine power for reasons that could not be determined because engine examination, an engine test run, and review of engine monitor data did not reveal any evidence of preimpact anomalies that would have precluded normal operation.Feb 23, 2016 · N256CD · Substantial damageNTSB ERA16LA103Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Miami, FLA partial loss of engine power for reasons that could not be determined because postaccident examination of the airplane revealed no mechanical anomalies that would have contributed to the power loss.Feb 2, 2016 · N8466G · Substantial damageNTSB DCA16CA077Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Titusville, FLan inadvertent encounter with clear air turbulence.Jan 28, 2016 · N718SW · No damage