NTSB investigations, 2021

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
NTSB investigations, 2021 per year, 1962–2026: 180,581 cases
196272
196378
19645,253
19655,377
19665,912
19676,339
19685,199
19695,027
19704,915
19714,825
19724,430
19734,398
19744,565
19754,403
19764,314
19774,412
19784,624
19794,165
19803,921
19813,836
19823,545
19833,514
19843,405
19853,055
19862,831
19872,774
19882,685
19892,502
19902,479
19912,419
19922,328
19932,283
19942,229
19952,281
19962,150
19972,121
19982,195
19992,175
20002,183
20012,031
20022,000
20032,062
20041,930
20052,001
20061,826
20071,984
20081,882
20091,783
20101,786
20111,848
20121,834
20131,561
20141,534
20151,581
20161,662
20171,635
20181,687
20191,626
20201,396
20211,645
20221,700
20231,678
20241,693
20251,655
20261,342

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\") = 2021
  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 WPR22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Mojave, CAThe pilot’s failure to maintain airplane control during an encounter with a wind gust during taxi.Dec 31, 2021 · N89084 · Substantial damageNTSB WPR22FA073Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Marana, AZThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions. Contributing to the accident was the pilot’s impairment due to use of methamphetamine before the flight.Dec 31, 2021 · N6796N · Substantial damageNTSB ERA22FA098Accident · 4 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Bronson, FLA loss of control due to spatial disorientation as a result of the noninstrument-rated pilot’s improper decision to attempt a visual flight rules flight at night into an area of known reduced visibility due to fog.Dec 31, 2021 · N442VB · DestroyedNTSB DCA22LA053Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330 · Newark, NJTurkish Airlines flightcrew’ s misperception of the distance to safely pass the stopped Republic Airways airplane.Dec 31, 2021 · TC-JOK · 2 aircraft · Minor damageNTSB WPR22LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150C · Johnsondale, CAThe pilot’s failure to maintain directional control of the airplane while landing on a snow-covered unimproved runway.Dec 30, 2021 · N7801Z · Substantial damageNTSB CEN22LA091Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Presidio, TXThe non-certificated pilot’s failure to perform a preflight weight and balance calculation and his decision to operate the airplane beyond the allowable center of gravity limitations, which resulted in a loss of control and impact with terrain.Dec 30, 2021 · N8591W · Substantial damageNTSB CEN22LA087Accident · 1 fatalClass 3 · LimitedFinal reportJ&J Ultralights Seawing · Golden, MOThe noncertificated pilot’s failure to maintain aircraft control while aggressively maneuvering at low altitude.Dec 30, 2021 · N285SW · Substantial damageNTSB CEN22FA086Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Livingston, TXThe pilot exceeding the yaw control capability of the helicopter for the flight conditions, resulting in a non-mechanical loss of tail rotor effectiveness.Dec 30, 2021 · N8AU · Substantial damageNTSB GAA22WA062Accident · No injuriesClass 5 · ForeignCessna A188 · Yopal, ColombiaDec 29, 2021 · HK2014 · Substantial damageNTSB GAA22WA061Accident · 2 fatalClass 5 · ForeignBell 412 · Quillen-Neuquen district, ArgentinaDec 29, 2021 · LV-KAI · DestroyedNTSB ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.Dec 29, 2021 · N6295E · Substantial damageNTSB ERA22LA097Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 207 · Marathon, FLA total loss of engine power due to the failure of the No. 2 bearing, which resulted in the No. 2 connecting rod failing due to fatigue, high heat, and stress.Dec 29, 2021 · N1596U · Minor damageNTSB ERA22FA096Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Cosby, TNThe pilot’s intentional, continued flight into instrument meteorological conditions in a helicopter that was not certified for instrument conditions, which resulted in a loss of helicopter control and a collision with trees and terrain.Dec 29, 2021 · N544SC · Substantial damageNTSB WPR22FA068Accident · 4 fatalClass 3 · FieldFinal reportGates Learjet 35A · El Cajon, CAThe flight crew’s decision to descend below the published MDA, cancel their IFR clearance to conduct an unauthorized circle-to-land approach to another runway while the airport was in nighttime IFR conditions, and the exceedance of the airplane’s critical…Dec 28, 2021 · N880Z · DestroyedNTSB CEN22LA085Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · West Helena, ARThe malfunction of the propeller autofeather system after takeoff for undetermined reasons, which resulted in both propellers going into feather and a hard landing.Dec 28, 2021 · N93GT · Substantial damageNTSB GAA22WA065AccidentClass 5 · ForeignCessna 172L · Koggala, Sri LankaDec 27, 2021 · 4R-GAF · Substantial damageNTSB ERA22FA095Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Jacksonville, FLThe pilot’s failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall/spin. Contributing was the pilot’s likely distraction due to the opening of the baggage door.Dec 26, 2021 · N3707H · Substantial damageNTSB CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…Dec 26, 2021 · N5798T · DestroyedNTSB DCA22WA203IncidentClass 5 · ForeignAirbus A330 · Montreal, CanadaDec 25, 2021 · C-GFAF · Minor damageNTSB CEN22LA089Accident · Minor injuriesClass 3 · LimitedFinal reportLancair IV · Iron Mountain, MIThe total loss of engine power after takeoff for undetermined reasons.Dec 25, 2021 · N994PT · Substantial damageNTSB CEN22LA088Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Rainbow, TXThe pilot’s improper decision to conduct an intentional low altitude flight which resulted in a collision with wires and impact with terrain.Dec 25, 2021 · N64602 · Substantial damageNTSB ANC22LA015Accident · No injuriesClass 4 · LimitedFinal reportEurocopter France AS350B2 · Kahului, HIThe pilot’s abrupt flight control inputs to correct for dynamic rollover, resulting in a hard landing.Dec 25, 2021 · N752CH · Substantial damageNTSB GAA22WA056Accident · 1 fatalClass 5 · ForeignAmateur Built D11 · South Mackay, AustraliaDec 24, 2021 · VH-WBL · Substantial damageNTSB WPR22LA069Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172N · Auburn, CAThe pilot’s failure to maintain altitude during an instrument approach, which resulted in an impact with power lines.Dec 22, 2021 · N6280F · Substantial damageNTSB WPR22FA067Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Show Low, AZThe pilot’s exceedance of the airplane’s critical angle of attack following an aborted landing approach, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.Dec 22, 2021 · N6000Z · DestroyedNTSB GAA22WA073Incident · No injuriesClass 5 · ForeignPiper PA38 · Katukurunda, Sri LankaDec 22, 2021 · 4R-ASJ · Minor damageNTSB WPR22LA078Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Strawberry, AZThe pilot’s failure to maintain clearance from a static wire during approach.Dec 21, 2021 · N111AD · Substantial damageNTSB GAA22WA057AccidentClass 5 · ForeignLearjet 35A · Cancun, MexicoDec 21, 2021 · XA-VDK · Substantial damageNTSB GAA22WA054Accident · 1 fatalClass 5 · ForeignCirrus Design SR22 · Auxerre, FranceDec 21, 2021 · N565CK · DestroyedNTSB GAA22WA053IncidentClass 5 · ForeignPiper PA34 · Newcastle, IrelandDec 21, 2021 · G-OBUC · Substantial damageNTSB ERA22LA092Accident · Serious injuriesClass 4 · LimitedFinal reportBeech D55 · Hamilton, ALThe pilot’s failure to properly configure the airplane’s fuel system, which resulted in a loss of engine power on the left engine due to fuel starvation.Dec 21, 2021 · N44DC · Substantial damageNTSB CEN22LA084Accident · No injuriesClass 4 · LimitedFinal reportTextron 525 · Dubuque, IAAn inflight collision with a flock of geese that resulted in substantial damage to the vertical stabilizer.Dec 21, 2021 · N287CB · Substantial damageNTSB CEN22FA081Accident · 2 fatalClass 3 · FieldFinal reportCessna 208 · Fulshear, TXThe limitations of the see-and-avoid concept as a method for self-separation of aircraft, which resulted in an inflight collision. Contributing to the accident was the absence of collision avoidance technology on both aircraft.Dec 21, 2021 · N1116N · 2 aircraft · DestroyedNTSB WPR22LA066Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons U S A-315 · Phoenix, AZThe pilot’s inability to maintain balloon control during a high wind landing, which resulted in a serious passenger injury.Dec 20, 2021 · N317RR · No damageNTSB DCA22WA054IncidentClass 5 · ForeignBoeing 777 · Dubai, United Arab EmiratesDec 20, 2021 · A6-EQI · Minor damageNTSB GAA22WA180Accident · Minor injuriesClass 5 · ForeignBell 206 · Santa Ana Mountain, ColombiaDec 18, 2021 · HK4511 · Substantial damageNTSB GAA22WA063Accident · 4 fatalClass 4 · ForeignRockwell 114 · Redcliffe, AustraliaDec 18, 2021 · VH-WMM · DestroyedNTSB GAA22WA055Accident · Minor injuriesClass 5 · ForeignMcdonnell Douglas 500 · Unteriberg, SwitzerlandDec 18, 2021 · HB-ZBM · Substantial damageNTSB GAA22WA052Accident · 1 fatalClass 5 · ForeignPiper 25-260 · Vereda Aparco, Ibague, ColombiaDec 18, 2021 · HK1405 · Substantial damageNTSB DCA22WA083AccidentClass 5 · ForeignDouglas DC9 · Diffa, NigerDec 18, 2021 · TT-ABC · Substantial damageNTSB CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.Dec 18, 2021 · N5677V · DestroyedNTSB GAA22WA051Accident · No injuriesClass 3 · ForeignRobinson R66 · Boca de Yuma, Dominican RepublicDec 17, 2021 · HI-982 · Substantial damageNTSB ERA22LA090Accident · 2 fatalClass 3 · LimitedFinal reportAerofab Lake LA-4-250 · Auburndale, FLA bird strike, which resulted in a loss of control while flying at low altitude over a lake.Dec 17, 2021 · N1402C · DestroyedNTSB WPR22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Ivanhoe, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose over.Dec 16, 2021 · N3744P · Substantial damageNTSB ERA22LA089Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Knoxville, TNThe pilot’s encounter with a wake vortex from a preceding airplane, which resulted in a roll upset at an altitude too low for recovery. Contributing to the accident was the failure of ATC to issue a wake turbulence cautionary advisory.Dec 16, 2021 · N162AM · DestroyedNTSB CEN22LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Houston, TXThe instructed pilot and the flight instructor’s failure to extend the landing gear before landing resulting in a wheels up landing.Dec 16, 2021 · N19VS · Substantial damageNTSB GAA22WA076Accident · No injuriesClass 5 · ForeignCessna 172 · Pallisa-KAGWARA, UgandaDec 15, 2021 · 5X-KYO · Substantial damageNTSB GAA22WA050Accident · 9 fatalClass 5 · ForeignGulfstream GIV · Santo Domingo, Dominican RepublicDec 15, 2021 · HI-1050 · DestroyedNTSB ANC22LA011Accident · No injuriesClass 3 · LimitedFinal reportLarry Bingham LB-1 · Haines, AKA partial loss of engine power for reasons that could not be determined based on available information, which resulted in a precautionary landing and impact with snow.Dec 15, 2021 · N555LB · Substantial damageNTSB ENG22WA048Accident · No injuriesClass 4 · ForeignEmbraer EMB500 · Santa Rosa, BrazilDec 14, 2021 · PR-TDV · Substantial damage