Final NTSB investigations, 2020

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

Cases per year

20082026
Final NTSB investigations, 2020 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\") = 2020
    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 CEN21LA102Accident · 1 fatalClass 3 · LimitedFinal reportHughes 369D · Tuckers Crossing, MSThe pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…Dec 29, 2020 · N103SU · DestroyedNTSB CEN21LA100Accident · Serious injuriesClass 3 · LimitedFinal reportWalton Daniel J Sonex · Pecatonica, ILA total loss of engine power for reasons that could not be determined based on the available information, and the pilot’s exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall/spin and…Dec 24, 2020 · N610DJ · Substantial damageNTSB WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.Dec 10, 2020 · N577CP · Substantial damageNTSB WPR21LA032Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · Billings, MTThe pilot’s failure to maintain the proper descent glide path while on final approach for reasons that could not be determined from available evidence.Oct 31, 2020 · N124TW · Substantial damageNTSB CEN21LA035Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Crystal Beach, TXThe partial loss of engine power for reasons that could not be determined.Oct 26, 2020 · N32458 · Substantial damageNTSB CEN21FA024Accident · 1 fatalClass 3 · FieldFinal reportGlasair III · Ford Heights, ILThe loss of engine power for reasons that could not be determined based on the available evidence.Oct 20, 2020 · N713MJ · Substantial damageNTSB CEN21LA018Accident · 2 fatalClass 3 · LimitedFinal reportCessna T182 · Houma, LAImpact with terrain for reasons that could not be determined with the available information.Oct 16, 2020 · N707DA · Substantial damageNTSB CEN21LA004Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Lake Elmo, MNA total loss of engine power for reasons that could not be determined.Oct 2, 2020 · N62ZM · Substantial damageNTSB WPR20LA320Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T1A · San Diego, CAA loss of engine power for reasons that could not be determined, which resulted in a hard landing off airport.Sep 24, 2020 · N3617L · Substantial damageNTSB CEN20LA413Accident · FatalClass 3 · LimitedFinal reportCosmos Phase 3 · Wayne, OKA loss of control while taxiing for reasons that could not be determined based on available evidence.Sep 19, 2020 · N7024L · Substantial damageNTSB CEN20LA392Accident · 3 fatalClass 3 · LimitedFinal reportCessna 172 · Cottage Grove, MNA steep descent and impact with terrain for reasons that could not be determined based on the available information.Sep 13, 2020 · N8488L · DestroyedNTSB WPR20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 208 · Whitmore, AZA loss of directional control during landing due to a flat main landing gear tire, which resulted in a lateral runway excursion and impact with terrain.Sep 7, 2020 · N186GC · Substantial damageNTSB CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.Sep 7, 2020 · N4636D · Substantial damageNTSB ERA20LA302Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Fletcher, NCA partial loss of engine power for reasons that could not be determined based on available evidence.Aug 27, 2020 · N9341N · Substantial damageNTSB ANC20LA083Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS350 · Ninilchik, AKA loss of engine power for an undetermined reason.Aug 25, 2020 · N160SH · Substantial damageNTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe 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 based on the available evidence.Aug 20, 2020 · N198DM · DestroyedNTSB CEN20LA342Accident · Minor injuriesClass 3 · LimitedFinal reportSiebel Auriga · Rockford, ILThe total loss of engine power for reasons that could not be determined based on available information.Aug 14, 2020 · N505JS · Substantial damageNTSB CEN20LA328Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Marathon, TXThe in-flight loss of helicopter control for reasons that could not be determined based on the available evidence.Aug 8, 2020 · N284S · DestroyedNTSB WPR20LA225Accident · No injuriesClass 3 · LimitedFinal reportVans RV 8 · Grimes, CAA partial loss of engine power for reasons that could not be determined because the airplane was not examined.Jul 17, 2020 · N508CM · Substantial damageNTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…Jul 10, 2020 · N6917K · DestroyedNTSB CEN20LA267Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Tornado · Mankato, KSA total loss of engine power for reasons that could not be determined based on available information.Jul 6, 2020 · N900WH · Substantial damageNTSB CEN20LA266Accident · Serious injuriesClass 3 · LimitedFinal reportLancair ES-P · Pauls Valley, OKThe reason for this accident could not be determined based on the available information.Jul 6, 2020 · N444TW · DestroyedNTSB CEN20LA287Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Des Arc, ARA total loss of engine power for reasons that could not be determined from all available evidence.Jul 3, 2020 · N8506E · Substantial damageNTSB CEN20LA269Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Weldon, ARThe total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.Jul 3, 2020 · N602NY · Substantial damageNTSB WPR20LA201Accident · 1 fatalClass 3 · LimitedFinal reportAvia Stroitel AC-5M · Bend, ORA loss of control just after takeoff for reasons that could not be determined based on the available information.Jun 30, 2020 · N263R · DestroyedNTSB WPR20LA191Accident · 1 fatalClass 3 · LimitedFinal reportEnstrom 280 · Hayden, IDThe total loss of power while maneuvering at low altitude due to the detonation of two engine cylinders and damaged spark plugs.Jun 24, 2020 · N280MM · DestroyedNTSB WPR20LA190Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · North Las Vegas, NVA total loss of engine power for reasons that could not be determined based on the available information.Jun 23, 2020 · N202CC · Substantial damageNTSB CEN20LA215Accident · 1 fatalClass 3 · LimitedFinal reportMitsubishi MU2B · Sioux Falls, SDThe pilot’s failure to maintain control of the airplane during takeoff for reasons that could not be determined.Jun 7, 2020 · N44MX · DestroyedNTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.Jun 6, 2020 · N13520 · DestroyedNTSB CEN20LA187Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · West Branch, MIThe pilot's failure to maintain rotor rpm during a precautionary autorotation, which resulted in a hard landing. Contributing to the accident was the airframe vibration for reasons that could not be determined because examination of the helicopter revealed no…May 20, 2020 · N153SA · Substantial damageNTSB CEN20LA179Accident · 1 fatalClass 3 · LimitedFinal reportCessna P210 · Burlington, WIThe pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.May 15, 2020 · N1JA · Substantial damageNTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.Apr 1, 2020 · N9883R · Substantial damageNTSB ERA20LA134Accident · 2 fatalClass 3 · LimitedFinal reportMaule MT-7 · Swansboro, NCThe airplane’s turning descent into water while enroute in night instrument meteorological conditions for reasons that could not be determined.Mar 24, 2020 · N899ZZ · DestroyedNTSB CEN20LA107Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Cabool, MOThe loss of engine power due to failure of the No. 1 cylinder piston for reasons that could not be determined based on available evidence.Feb 29, 2020 · N601ND · Substantial damageNTSB CEN20FA098Accident · 1 fatalClass 3 · FieldFinal reportInnovator Mosquitto · North Manchester, INThe pilot’s loss of control for reasons that could not be determined based on the available information.Feb 23, 2020 · N840GS · Substantial damageNTSB CEN20LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Aledo, TXThe in-flight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.Feb 12, 2020 · N654CE · Substantial damageNTSB CEN20LA055Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 100 · Mullin, TXA total loss of engine power for reasons that could not be determined based on the available information.Jan 4, 2020 · N5573M · Substantial damage