Final NTSB investigations, 2022

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

Cases per year

20082026
Final NTSB investigations, 2022 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\") = 2022
    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 ERA23LA093Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Annapolis, MDA reported partial loss of engine power for undetermined reasons.Dec 26, 2022 · N1867H · Substantial damageNTSB CEN23LA066Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Harrison, ARA loss of engine power for reasons that could not be determined.Dec 19, 2022 · N8137P · Substantial damageNTSB CEN23FA060Accident · 3 fatalClass 3 · FieldFinal reportBeech F33A · Yukon, OKThe pilot’s loss of airplane control for reasons that could not be determined.Dec 6, 2022 · N9142Q · DestroyedNTSB WPR23LA060Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Willow Spring, AZThe airplane’s loss of engine power for undetermined reasons.Nov 27, 2022 · N2994X · Substantial damageNTSB CEN23LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Durango, COA complete loss of engine power for reasons that could not be determined from the available evidence.Nov 24, 2022 · N3886D · Substantial damageNTSB ERA23LA068Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Manassas, VAA total loss of engine power for reasons that could not be determined based on the available evidence.Nov 21, 2022 · N7261F · Substantial damageNTSB CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.Nov 18, 2022 · N6797L · DestroyedNTSB ERA23FA047Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G58 · Alpharetta, GAThe pilot’s loss of aircraft control for unknown reasons.Oct 31, 2022 · N495AU · DestroyedNTSB CEN23LA022Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · Evansville, INThe total loss of engine power for reasons that could not be determined based on the available evidence.Oct 30, 2022 · N349SB · Substantial damageNTSB ERA23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Lake Worth, FLA loss of engine power for reasons that could not be determined.Oct 23, 2022 · N39628 · Substantial damageNTSB WPR23LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Tucson, AZThe pilot’s loss of control during landing for reasons that could not be determined based on the available evidence.Oct 15, 2022 · N7746Y · Substantial damageNTSB CEN23LA014Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 62 · Dallas, TXA total loss of airplane electrical power for undetermined reasons, which resulted in a complete loss of engine power to both engines. Contributing was the worn main battery and the incorrectly wired ECU backup batteries.Oct 15, 2022 · N84LT · Substantial damageNTSB WPR23FA007Accident · 1 fatalClass 3 · FieldFinal reportCornford Craig H Mustang II · Jamul, CAImpact with mountainous terrain for undetermined reasons due to the limited evidence that could be collected from the accident sceneOct 4, 2022 · N887QR · DestroyedNTSB WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…Sep 16, 2022 · N646RV · DestroyedNTSB WPR22LA352Accident · No injuriesClass 3 · LimitedFinal reportJacquneaux Glen R CGS Hawk · Lander, WYA reported severe airframe vibration and subsequent forced landing for reasons that could not be determined because the wreckage was not made available for examination.Sep 15, 2022 · N5148G · Substantial damageNTSB ERA22LA416Accident · No injuriesClass 3 · LimitedFinal reportWilliam L Bell Vans RV-7A · Warrenton, VAA total loss of engine power for reasons that could not be determined because the airplane could not be examined.Sep 13, 2022 · N40WB · Substantial damageNTSB ERA22LA401Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Wadsworth, OHA total loss of engine power for reasons that could not be determined.Sep 3, 2022 · N5666U · Substantial damageNTSB CEN22LA403Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Houghton Lake, MIA loss of engine power during cruise flight for undetermined reasons.Aug 31, 2022 · N2270L · Substantial damageNTSB ANC22FA069Accident · 1 fatalClass 3 · FieldFinal reportStory Charles Brad TT FOX · Wasilla, AKThe pilot’s inability to maintain control of the airplane for reasons that could not be determined.Aug 29, 2022 · N2723P · Substantial damageNTSB ERA22LA389Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 140 · Slocomb, ALThe partial loss of engine power during takeoff for reasons that could not be determined.Aug 27, 2022 · N76527 · Substantial damageNTSB WPR22LA317Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design General Avn Ctsw SuperSport · Boulder City, NVA total loss of engine power for undetermined reasons.Aug 26, 2022 · N916CA · Substantial damageNTSB WPR22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-30 · St Ignatius, MTA partial loss of power during takeoff for undetermined reasons.Aug 23, 2022 · N4009Y · Substantial damageNTSB ERA22LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Marathon, FLA total loss of power for undetermined reasons.Aug 19, 2022 · N587FL · Substantial damageNTSB ERA22FA376Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Glendora, MSThe collision with terrain for reasons that could not be determined.Aug 19, 2022 · N602PB · Substantial damageNTSB CEN22FA376Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Centennial, COThe loss of engine power during a departure climb for undetermined reasons and the aerodynamic stall, which resulted in an uncontrolled descent and impact with terrain.Aug 9, 2022 · N727PC · DestroyedNTSB CEN22FA375Accident · 1 fatalClass 3 · FieldFinal reportSonex Waiex · Maxwell, CAA loss of control in flight for undetermined reasons that resulted in an impact with terrain.Aug 9, 2022 · N51YX · DestroyedNTSB CEN22LA361Accident · No injuriesClass 3 · LimitedFinal reportVans RV-10 · Hurst, ILA loss of engine power for reasons that could not be determined.Aug 3, 2022 · N255CP · Substantial damageNTSB CEN22LA354Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Lamoni, IAA loss of airplane performance for reasons that could not be determined.Aug 1, 2022 · N4326S · DestroyedNTSB ERA22LA346Accident · Serious injuriesClass 3 · LimitedFinal reportTextron G36 · Ridgeland, SCA loss of engine power for reasons that could not be determined.Jul 30, 2022 · N887MJ · Substantial damageNTSB ERA22LA345Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Ephratah, NYA loss of engine power for undetermined reasons.Jul 30, 2022 · N1358K · Substantial damageNTSB CEN22LA349Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Knox, INA partial loss of engine power for undetermined reasons.Jul 26, 2022 · N629EH · Substantial damageNTSB CEN22LA323Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Verona, ILA loss of rotor rpm for reasons that could not be determined.Jul 18, 2022 · N6BU · Substantial damageNTSB WPR22FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna T337G · Gold Hill, COThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering with one engine inoperative, which resulted in an aerodynamic stall/spin and impact with terrain.Jul 17, 2022 · N337KN · DestroyedNTSB CEN22LA313Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Rapid City, SDA total loss of engine power for reasons that could not be determined because the airplane was unavailable for examination.Jul 11, 2022 · N478WT · Substantial damageNTSB ERA22LA302Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Center Cross, VAA loss of engine power for reasons that could not be determined.Jul 8, 2022 · N50075 · Substantial damageNTSB ANC22LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 182D · McGrath, AKA nose landing gear collapse during landing for reasons that could not be determined based on the available information.Jul 6, 2022 · N8754X · Substantial damageNTSB CEN22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Aurora, COA total loss of engine power due to foreign object debris blockage of engine air intake. The source of the debris could not be determined based on the available information.Jul 3, 2022 · N184CB · Substantial damageNTSB CEN22LA311Accident · No injuriesClass 3 · LimitedFinal reportRotorsport UK MTOSport 2017 · Mead, OKA partial loss of engine power for reasons that could not be determined.Jul 1, 2022 · N44AL · Substantial damageNTSB ERA22LA366Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT · Wilmington, NCA partial loss of engine power during initial climb for reasons that could not be determined.Jun 29, 2022 · N4321M · Substantial damageNTSB WPR22LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · San Carlos, CAThe total loss of engine power for undetermined reasons.Jun 28, 2022 · N2056V · Substantial damageNTSB ANC22FA047Accident · 1 fatalClass 3 · FieldFinal reportBell UH1B · Clear, AKA loss of control for reasons that could not be determined based on the available information.Jun 27, 2022 · N9970F · DestroyedNTSB ERA22LA283Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-18A · Charlestown, NHThe pilot’s failure to see and avoid power lines while maneuvering at low altitude.Jun 22, 2022 · N1927A · Substantial damageNTSB ERA22LA287Accident · Serious injuriesClass 3 · LimitedFinal reportMantell Allan T Lightning · Canandaigua, NYThe pilot’s performance of an off-airport landing shortly after takeoff for reasons that could not be determined.Jun 21, 2022 · N51TM · Minor damageNTSB WPR22FA215Accident · 2 fatalClass 3 · FieldFinal reportBeech E35 · Buckeye, AZThe pilots’ failure to climb and complete a normal traffic pattern after making a low approach and their failure to extend the flaps for reasons that could not be determined, and the flight instructor’s failure to ensure adequate airspeed and bank control…Jun 18, 2022 · N13AR · DestroyedNTSB WPR22LA221Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Stockton, CATail rotor blade impact with an unidentified object, which resulted in the loss of control and subsequent rollover of the helicopter.Jun 17, 2022 · N90326 · Substantial damageNTSB CEN22LA252Accident · No injuriesClass 3 · LimitedFinal reportMeyers Industries 200A · Weslaco, TXA total loss of engine power for reasons that could not be determined.Jun 16, 2022 · N489C · Substantial damageNTSB CEN22LA247Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Olla, LAThe partial loss of engine power for undetermined reasons.Jun 9, 2022 · N416TS · Substantial damageNTSB CEN22FA232Accident · 2 fatalClass 3 · FieldFinal reportCessna 182G · Kenedy, TXA loss of airplane control on final approach for reasons that could not be determined.Jun 6, 2022 · N2118R · DestroyedNTSB WPR22LA202Accident · Minor injuriesClass 3 · LimitedFinal reportFischer Super Koala · Chelan, WAA total loss of engine power for undetermined reasons.Jun 5, 2022 · UNREG · Substantial damageNTSB CEN22LA259Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Mesquite, TXA collapse of the airplane’s landing gear during the landing roll for reasons that could not be determined based on the available information.Jun 5, 2022 · N9475Y · Substantial damage