Final NTSB investigations, 2019

37 cases where the sequence of events included Unknown or undetermined.

Cases per year

20082026
Final NTSB investigations, 2019 per year, 2008–2026: 592 cases
200810
200922
201032
201124
201231
201317
201425
201522
201622
201714
201820
201937
202037
202146
202275
202397
202451
202510

Latest cases

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 year(c.\"eventDate\") = 2019
    AND c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' 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 ANC20MA010Accident · 7 fatalClass 1 · MajorFinal reportAirbus AS350B2 · Kekaha, HIThe pilot’s decision to continue flight under visual flight rules (VFR) into instrument meteorological conditions (IMC), which resulted in the collision into terrain. Contributing to the accident was Safari Aviation Inc.’s lack of safety management processes…Dec 27, 2019 · N985SA · DestroyedNTSB CEN20FA019Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · San Marcos, TXThe pilot’s loss of control shortly after takeoff in instrument meteorological conditions for reasons that could not be determined based on the available information.Nov 20, 2019 · N88855 · DestroyedNTSB WPR20LA028Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Metaline, WAImpact with a lake for reasons that could not be determined.Nov 11, 2019 · N8749T · DestroyedNTSB CEN20LA017Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TB 30 Epsilon · Kalamazoo, MIA total loss of engine power for undetermined reasons, which resulted in an aerodynamic stall during the pilot’s attempted forced landing at low altitude and impact with terrain.Nov 1, 2019 · N50TB · Substantial damageNTSB ERA20FA025Accident · 1 fatalClass 3 · FieldFinal reportVans RV 4 · Middleburg, FLImpact with power lines for reasons that could not be determined based on available evidence.Oct 31, 2019 · N425JW · DestroyedNTSB WPR20FAMS1Accident · 2 fatalClass 3 · Missing aircraftFinal reportPiper PA28R · Shelter Cove, CAUndetermined due to lack of available evidence.Oct 25, 2019 · N4958J · DestroyedNTSB WPR20LA014Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 6 · Spanaway, WAA total loss of engine power during the initial climb for reasons that could not be determined.Oct 23, 2019 · N615RJ · Substantial damageNTSB WPR20FA013Accident · 2 fatalClass 3 · FieldFinal reportRobinson R44 · Las Vegas, NVAn undetermined inflight event that resulted in the pilot performing an autorotation to uneven terrain for reasons that could not be determined due to the extent of impact damage.Oct 23, 2019 · N225JM · Substantial damageNTSB CEN20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV-8 · White Plains, ALImpact with terrain for reasons that could not be determined based on the available information.Oct 20, 2019 · N249BW · DestroyedNTSB CEN20LA021Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA23 · (Gulf of Mexico)The airplane’s descent into the ocean for reasons that could not be determined.Oct 17, 2019 · N778PA · DestroyedNTSB CEN20LA004Accident · No injuriesClass 3 · LimitedFinal reportBeech B36 · Ranger, TXA lack of climb performance after takeoff for reasons that could not be determined based on the available information.Oct 6, 2019 · N36LS · Substantial damageNTSB CEN20LA005Accident · No injuriesLimited investigationFinal reportZenair Zenith CH 701 · Garden Ridge, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.Oct 5, 2019 · N701BJ · Substantial damageNTSB WPR19LA267Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Modesto, CAA total loss of engine power for reasons that could not be determined based on the available information.Sep 28, 2019 · N8353T · DestroyedNTSB CEN19LA297Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Independence Charter Township, MIThe reduction in climb performance for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of performance.Sep 2, 2019 · N98278 · Substantial damageNTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.Aug 31, 2019 · N55633 · Substantial damageNTSB CEN19LA269Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Blair, NEThe loss of main rotor rpm for reasons that could not be determined based on the available evidence, which resulted in a hard landing.Aug 16, 2019 · N106PD · Substantial damageNTSB WPR19LA228Accident · Serious injuriesClass 3 · LimitedFinal reportHead AX9-118 · Galt, CAA loss of control following an adverse wind encounter.Aug 9, 2019 · N2027S · Minor damageNTSB CEN19FA248Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · De Queen, ARA loss of control for reasons that could not be determined based on the available information.Aug 4, 2019 · N310QA · Substantial damageNTSB CEN19FA238Accident · 2 fatalClass 3 · FieldFinal reportPiper PA34 · Gainesville, TXThe pilots’ failure to maintain airspeed while on final approach with asymmetric engine power, which resulted in a loss of control.Jul 28, 2019 · N456AG · DestroyedNTSB WPR19LA202Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Port Townsend, WAThe loss of engine power for reasons that could not be determined based on available information.Jul 21, 2019 · N3863L · Substantial damageNTSB WPR19FA188Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Hayward, CAThe pilots’ loss of control during a low altitude maneuver for undetermined reasons, which resulted in impact with terrain.Jul 15, 2019 · N144TG · Substantial damageNTSB CEN19FA221Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Katy, TXThe pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.Jul 13, 2019 · N517LA · DestroyedNTSB ERA19LA221Accident · 1 fatalClass 3 · LimitedFinal reportTeam Mini-Max Hi-Max · Monroe, GAA collision with terrain for undetermined reasons.Jul 9, 2019 · UNREG · DestroyedNTSB CEN19MA190Accident · 10 fatalClass 2 · MajorFinal reportTextron B-300 · Addison, TXThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…Jun 30, 2019 · N534FF · DestroyedNTSB WPR19FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172 · Pescadero, CAImpact with the ocean for reasons that could not be determined because the airplane was not located.Jun 27, 2019 · N3504A · DestroyedNTSB WPR19LA168Accident · Minor injuriesClass 3 · LimitedFinal reportSikorsky UH19 · Brewster, WAA reported mechanical malfunction and a hard landing for reasons that could not be determined based on available evidence.May 29, 2019 · N955TC · Substantial damageNTSB WPR19LA155Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Garberville, CAA total loss of engine power for reasons that could not be determined based on the available information.May 26, 2019 · N8746S · Substantial damageNTSB GAA19CA284Accident · No injuriesData collectionFinal reportSchweizer 269C · Riverside, CAThe student pilot's failure to maintain yaw control and the engine's rpm during transition to a hover, which resulted in hard landing.May 24, 2019 · N269P · Substantial damageNTSB ERA19LA180Accident · 1 fatalLimited investigationFinal reportCessna 560 · Atlantic Ocean (Atlantic Ocean)Impact with water for reasons that could not be determined based on the available information.May 24, 2019 · N832R · DestroyedNTSB CEN19FA144Accident · 1 fatalClass 2 · FieldFinal reportVans RV6 · Chillicothe, OHThe pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…May 18, 2019 · N596JB · DestroyedNTSB GAA19CA282Accident · No injuriesData collectionFinal reportCessna 172 · Edwards Air Force Base, CAAn undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence.Apr 28, 2019 · N106ED · Substantial damageNTSB CEN19LA127Accident · No injuriesClass 3 · LimitedFinal reportBeech 50 · Sheldon, MOA partial loss of engine power on both engines due to detonation for undetermined reasons.Apr 26, 2019 · N29Y · Substantial damageNTSB WPR19LA120Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 225 DD · McCall, IDA total loss of engine power for reasons that could not be determined based on the available information.Apr 23, 2019 · N727WW · Substantial damageNTSB CEN19LA085Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P92 · Englewood, COThe loss of engine power for undetermined reasons, because the airplane wreckage was sold and relocated before the engine could be examined.Feb 21, 2019 · N108TE · Substantial damageNTSB CEN19LA091Accident · Serious injuriesClass 3 · LimitedFinal reportVan's RV-8 · Horseshoe Bay, TXA total loss of engine power for reasons that could not be determined based on the available information.Feb 15, 2019 · N737MC · Substantial damageNTSB CEN19FA072Accident · 3 fatalClass 1 · FieldFinal reportBell 407 · Zaleski, OHThe NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…Jan 29, 2019 · N191SF · DestroyedNTSB CEN19LA069Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Port Lavaca, TXA total loss of engine power for reasons that could not be determined based on the available information.Jan 10, 2019 · N2391S · Substantial damage