NTSB investigations

19,222 cases where NTSB found Aircraft.

Cases, newest first

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 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 CEN21LA474Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion H · Burlington, WIThe pilot’s failure to maintain aircraft control during landing with a gusting crosswind that resulted in an aerodynamic stall and a hard impact on the runway.Sep 16, 2021 · N1061Y · Substantial damageNTSB CEN21LA430Accident · No injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Battle Creek, MIThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing and the flight instructor’s inadequate remedial action.Sep 16, 2021 · N53GL · Substantial damageNTSB CEN21LA423Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Howell, MIThe pilot’s inadequate preflight inspection of the airplane’s fuel quantity, which resulted in a total loss of engine power due to fuel starvation.Sep 16, 2021 · N823SP · Substantial damageNTSB CEN21LA422Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Ypsilanti, MIThe pilot’s failure to maintain directional control during taxi, which resulted in a ground loop.Sep 16, 2021 · N4358V · Substantial damageNTSB WPR21LA347Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Stanley, IDThe pilot’s failure to maintain airplane control during landing with a gusting crosswind which, resulted in a hard landing and collision with terrain.Sep 15, 2021 · N529PE · Substantial damageNTSB WPR21LA346Accident · Serious injuriesClass 4 · LimitedFinal reportGordon Scot A RV-6A · Palouse, WAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.Sep 15, 2021 · N3977G · Substantial damageNTSB CEN21LA433Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Council Bluffs, IAThe student pilot’s failure to maintain directional control during a touch and go landing.Sep 15, 2021 · N767CG · Substantial damageNTSB ERA21LA379Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft 400A · Charleston, SCThe in-flight separation of the left engine’s four-panel cowling for reasons that could not be determined based on the available evidence.Sep 14, 2021 · N100FN · Substantial damageNTSB ERA21LA375Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Andover Township, NJThe student pilot's excessive asymmetrical application of the brakes, which resulted in a nose over.Sep 14, 2021 · N948FS · Substantial damageNTSB ERA21LA360Accident · No injuriesClass 3 · LimitedFinal reportZenith 750 Cruzer · New Smyrna, FLThe mechanic’s inadequate inspection of the flight control system, which resulted in a loss of airplane control.Sep 14, 2021 · N161AR · Substantial damageNTSB CEN21LA425Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Mark III · Steamboat Springs, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Sep 14, 2021 · N4365E · Substantial damageNTSB WPR21LA342Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 58 · Palo Alto, CAThe fuelers addition of the incorrect fuel to the fuel tanks which resulted in a total loss of engine power.Sep 13, 2021 · N162DF · Substantial damageNTSB ERA21LA361Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C24R · Augustine, FLImproperly installed fuel injection system components, which resulted in a partial loss of engine power shortly after takeoff.Sep 13, 2021 · N5246M · Substantial damageNTSB ERA21LA358Accident · Minor injuriesClass 4 · LimitedFinal reportAlon A2 · Abingdon, VAThe failure of a nosewheel steering actuator arm, which resulted in a loss of control during the landing rollout.Sep 13, 2021 · N5644F · Substantial damageNTSB ERA21LA356Accident · No injuriesClass 3 · LimitedFinal reportWaco GXE · Burt, NYThe improper magneto timing, which resulted in the engine’s inability to produce full power during the takeoff.Sep 13, 2021 · N8564 · Substantial damageNTSB WPR21FA340Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Havasu City, AZA partial loss of engine power during the airplane's initial climb due to wear of internal engine components, which prevented the engine from developing full-rated power and resulted in a loss of altitude.Sep 12, 2021 · N2085Q · Substantial damageNTSB ERA21LA366Accident · No injuriesClass 4 · LimitedFinal reportSproul Keith A 83K-16 · Ryegate, VTThe pilot's failure to secure himself to the balloon seat which resulted in a loss of control of the balloon.Sep 12, 2021 · N83KX · Substantial damageNTSB ERA21FA355Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8KCAB · Rhine, GAA collision with trees during a low-altitude aerobatic maneuver for unknown reasons.Sep 12, 2021 · N390PE · Substantial damageNTSB CEN21LA418Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Magnolia, TXA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight planning.Sep 12, 2021 · N740FT · Substantial damageNTSB CEN21LA415Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170B · Ozark, ARThe pilot’s inadequate takeoff performance planning that resulted in a climb gradient too low to clear trees on departure, and his failure to maintain aircraft control that resulted in an aerodynamic stall and impact with terrain.Sep 12, 2021 · N2998D · Substantial damageNTSB ANC21LA086Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Port Alsworth, AKA loss of directional control for reasons that could not be determined based on the available information.Sep 12, 2021 · N6476M · Substantial damageNTSB WPR21LA358Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Baker, NVA total loss of engine power during the initial climb due to the failure of the No. 5 connecting rod bearing.Sep 11, 2021 · N8983M · Substantial damageNTSB ERA22LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Kennesaw, GAThe pilot's improper landing flare, which resulted in a hard, bounced landing.Sep 11, 2021 · N9522L · Substantial damageNTSB ERA21LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Ayer, MAThe pilot’ improper preflight and inflight planning which resulted in fuel exhaustion.Sep 11, 2021 · N912VW · Substantial damageNTSB CEN21LA420Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Ultralight Challenger II · Rogers City, MIThe separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…Sep 11, 2021 · N778H · Substantial damageNTSB ANC21LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and nose over.Sep 11, 2021 · N7MY · Substantial damageNTSB CEN21LA416Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Hot Springs, SDThe tensile overload failure of the main landing gear attachment bolt, which resulted in separation of the left main landing gear and a loss of control during landing.Sep 10, 2021 · N9343B · Substantial damageNTSB CEN21FA410Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Mentone, TXThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.Sep 10, 2021 · N292DD · Substantial damageNTSB ANC21LA087Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · North Pole, AKThe pilot’s failure to ensure adequate obstacle clearance while maneuvering, which resulted in a collision with a tree and a loss of control.Sep 10, 2021 · N1441H · Substantial damageNTSB ERA21LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Venice, FLMaintenance personnel’s failure to use the correct throttle linkage hardware when reinstalling the engine, resulting in a disconnection of the throttle during flight.Sep 9, 2021 · N782JA · Substantial damageNTSB CEN21LA419Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Marshalltown, IAThe pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.Sep 9, 2021 · N306TA · Substantial damageNTSB WPR21LA339Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Arlington, WAThe fatigue fracture of the tailwheel fitting spring, which resulted in the loss of directional control during the landing roll.Sep 8, 2021 · N185BB · Substantial damageNTSB WPR21LA338Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Tillamook, ORThe pilot's failure to maintain clearance from a powerline during a low reconnaissance, with sun glare.Sep 8, 2021 · N6516K · Substantial damageNTSB ERA21LA357Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F28 · Toughkenamon, PAThe pilot’s failure to maintain control of the helicopter during an out-of-ground effect hover in a gusty wind, due to loss of tail rotor effectiveness.Sep 8, 2021 · N51789 · Substantial damageNTSB CEN21LA407Accident · No injuriesClass 4 · LimitedFinal reportAeromot AMT-100 · Menomonie, WIThe pilot’s failure to extend the landing gear.Sep 7, 2021 · N69FW · Substantial damageNTSB ANC21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKThe pilot’s inability to maintain lateral control during the takeoff, which resulted in dynamic rollover. Contributing to the accident was the pilot’s decision to utilize an unsuitable landing area for flight operations.Sep 7, 2021 · N125KW · Substantial damageNTSB ERA21LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Philadelphia, PAThe pilot’s exceedance of the wing’s critical angle of attack, which resulted in an aerodynamic stall and loss of aircraft control.Sep 6, 2021 · N5166S · Substantial damageNTSB CEN21LA406Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Kingsley, IAThe total loss of engine power due to fuel exhaustion as a result of an unsecured fuel bladder, which reduced the fuel capacity of the affected tank.Sep 6, 2021 · N7574N · Substantial damageNTSB CEN21LA403Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Gunnison, COThe pilot’s failure to maintain directional control of the airplane after landing with a quartering tailwind.Sep 6, 2021 · N6XC · Substantial damageNTSB CEN21LA401Accident · No injuriesClass 3 · LimitedFinal reportBulfer James G Genesis · Fairmont, MNThe pilot’s failure to maintain airspeed during a forced landing, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the loss of power due to the failure of the engine’s…Sep 6, 2021 · N105BJ · Substantial damageNTSB CEN21LA396Accident · 1 fatalClass 3 · LimitedFinal reportMonnett Moni · Tulsa, OKAn aerodynamic stall/spin and loss of control for reasons that could not be determined based on the available information.Sep 6, 2021 · N983JV · Substantial damageNTSB ANC21LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Tyonek, AKThe pilot’s selection of inappropriate terrain and decision to land with a tailwind, which resulted in a loss of directional control, an attempted go-around, and subsequent impact with terrain.Sep 6, 2021 · N149AK · Substantial damageNTSB CEN21LA470Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Magee, MSThe pilot exceeded the airplane’s critical angle of attack during the landing approach resulting in an aerodynamic stall and subsequent hard landing.Sep 5, 2021 · N700DQ · Substantial damageNTSB CEN21LA402Accident · No injuriesClass 3 · LimitedFinal reportMurphy Renegade II · Sheridan, ILA total loss of engine power during initial climb due to a piston seizure.Sep 5, 2021 · N490DJ · Substantial damageNTSB WPR21LA336Accident · Serious injuriesClass 4 · LimitedFinal reportRagwing S1 · Arlington, WAThe pilot’s loss of directional control during landing.Sep 4, 2021 · N423JB · Substantial damageNTSB CEN21LA400Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Fort Wayne, INThe total loss of engine power after takeoff due to the formation of carburetor ice while on the ground and the pilot’s failure to apply carburetor heat immediately before takeoff.Sep 4, 2021 · N2071K · Substantial damageNTSB ANC21LA084Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Gustavus, AKThe pilot’s failure to maintain directional control during an off-airport beach landing.Sep 4, 2021 · N371SC · Substantial damageNTSB WPR21LA334Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Hurricane, UTThe pilot's failure to extend the landing gearSep 3, 2021 · N15DQ · Substantial damageNTSB ERA21LA393Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Delray, FLThe pilot’s inadequate preflight inspection and improper fuel planning which resulted in fuel exhaustion and subsequent loss of engine power.Sep 3, 2021 · N388RV · Substantial damageNTSB ERA21LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Fort Lauderdale, FLThe flight instructor’s loss of airplane control during an attempted go around maneuver, which resulted in an aerodynamic stall, and subsequent impact with the runway.Sep 3, 2021 · N65987 · Substantial damage