NTSB investigations, 2021

950 cases where NTSB found Aircraft.

Cases per year

19792026
NTSB investigations, 2021 per year, 1979–2026: 19,222 cases
19791
20081,297
20091,286
20101,161
20111,213
20121,206
20131,003
20141,047
20151,034
20161,075
20171,060
20181,065
20191,048
2020921
2021950
20221,010
2023975
2024933
2025643
2026294

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
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
  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 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 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 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 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 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 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 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 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 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 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 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 CEN22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Bridgeport, TXThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing. Contributing to the accident was the pilot’s improper placement of the throttle during the initial practice power-on recovery autorotation.Dec 14, 2021 · N862YB · Substantial damageNTSB CEN22LA077Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Crowley, TXThe student pilot’s encounter with a loss of tail rotor effectiveness during hover, and the flight instructor’s delayed remedial action that resulted in an emergency landing and impact with terrain.Dec 14, 2021 · N8827F · Substantial damageNTSB CEN22LA079Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Ellinwood, KSThe pilot's improper brake application during the landing roll, which resulted in a nose-over.Dec 13, 2021 · N1616K · Substantial damageNTSB ERA22LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Hazleton, PAThe pilot’s failure to maintain proper airspeed on approach in tailwind conditions, which resulted in an extended touchdown, bounced landing, and runway excursion.Dec 12, 2021 · N215LP · Substantial damageNTSB CEN22LA072Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL18 · Abbeville, LAAn electrical fire for reasons that could not be determined.Dec 12, 2021 · N1477D · DestroyedNTSB CEN22FA070Accident · 1 fatalClass 3 · FieldFinal reportCessna 310J · Inola, OKThe loss of airplane control for reasons that could not be determined based on the available evidence.Dec 12, 2021 · N3187L · DestroyedNTSB WPR22LA061Accident · 1 fatalClass 3 · LimitedFinal reportMoul Willis RV-3 · Bermuda Dunes, CAThe pilot’s improper positioning of the fuel shutoff valve, which resulted in a loss of engine power, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.Dec 11, 2021 · N9YY · Substantial damageNTSB ERA22LA108Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lake City, FLThe pilot’s loss of control during the landing flare, which resulted in a runway excursion.Dec 11, 2021 · N910WM · Substantial damageNTSB ERA22FA086Accident · 1 fatalClass 3 · FieldFinal reportSwearingen SA226 · Bedford, NHThe pilot’s failure to secure and feather the left engine and increase power on the right engine after a perceived loss of engine power in the left engine, which resulted in a loss of control and impact with terrain just short of the runway. Contributing to…Dec 11, 2021 · N54GP · DestroyedNTSB ERA22FA085Accident · 2 fatalClass 3 · FieldFinal reportBeech V35 · Crab Orchard, KYThe noninstrument-rated pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control and collision with terrain. Contributing to the accident was…Dec 10, 2021 · N5704V · Substantial damageNTSB WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.Dec 9, 2021 · N152BT · Substantial damageNTSB CEN22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Rockwall, TXThe pilot’s failure to go-around during the unstable visual approach, which resulted in a bounced touchdown near the end of the runway and the subsequent runway excursion.Dec 9, 2021 · N7157W · Substantial damageNTSB CEN22LA068Accident · Serious injuriesClass 4 · LimitedFinal reportCHR International Safari 400 · McKinney, TXThe pilot did not remove the cyclic control lock during preflight, which resulted in a loss of control during the initial hover.Dec 9, 2021 · N666JS · Substantial damageNTSB CEN22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Delta, COFuel starvation resulting in a loss of engine power.Dec 8, 2021 · N543AS · Substantial damageNTSB CEN22FA064Accident · 1 fatalClass 3 · FieldFinal reportVans RV-4 · Walsenburg, COThe pilot’s failure to maintain clearance from terrain while intentionally maneuvering in a canyon at low altitude. Contributing to the accident was the pilot’s decision to enter a canyon environment at a low altitude, and the sudden change in wind conditions…Dec 8, 2021 · N456MC · Substantial damageNTSB WPR22LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Corona, CAThe pilot receiving instruction failure to extend the landing gear before landing due to distraction and the flight instructor’s inadequate supervision.Dec 7, 2021 · N310CC · Substantial damageNTSB ERA22LA082Accident · Minor injuriesClass 3 · LimitedFinal reportBeech S35 · Tallahassee, FLA total loss of engine power due to a lack of oil lubrication.Dec 7, 2021 · N80YD · Substantial damageNTSB WPR22LA056Accident · No injuriesClass 4 · LimitedFinal reportMonte Clark Vans RV8 · Hamilton, MTThe pilot’s failure to maintain directional control while landing with a crosswind.Dec 5, 2021 · N889WT · Substantial damageNTSB ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.Dec 4, 2021 · N7824S · Substantial damageNTSB CEN22LA071Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Wichita Falls, TXThe pilot’s improper fuel management that resulted in a total loss of engine power due to fuel starvation.Dec 4, 2021 · N421RT · Substantial damageNTSB ERA22LA084Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, VACollision with a bird in flight, which resulted in damage to the right-wing leading-edge spar.Dec 3, 2021 · N2100S · Substantial damageNTSB CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.Dec 3, 2021 · N3372A · Substantial damageNTSB WPR22FA053Accident · 1 fatalClass 3 · FieldFinal reportRussell W Dyer Vortex · Lakeport, CAThe pilot’s loss of control for reasons that could not be determined and the delayed remedial action to recover from the power pushover event.Dec 2, 2021 · N425RD · Substantial damageNTSB CEN22LA059Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Cleveland, TXA total loss of engine power due to fuel starvation, the reason for which could not be determined.Dec 2, 2021 · N8038Z · Substantial damageNTSB ANC22LA009Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 208 · Port Alsworth, AKThe pilot's failure to maintain a proper approach path which resulted in landing short of the runway and impact with terrain.Dec 2, 2021 · N9602F · Substantial damageNTSB WPR22LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 510 · Havasu, AZThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.Dec 1, 2021 · N81CB · Substantial damageNTSB CEN22LA061Accident · Serious injuriesClass 4 · LimitedFinal reportExperimental Nieuport-12 · Midland, TXThe pilot’s loss of directional control during a high-speed taxi operation and subsequent collision with terrain during the inadvertent flight.Dec 1, 2021 · N12GX · Substantial damage