NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 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 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.
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 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN05CA105Accident · No injuriesData collectionFinal reportNavion Navion G · Parowan, UTThe jammed left main landing gear and the wheels up landing. Factors contributing to the accident were the misaligned left landing light and that landing gear extension was not possible.NTSB CHI05LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Allegan, MIThe inadequate aircraft control by the PA-28-180 pilot while the airplane was stopped.NTSB CHI05CA159Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Osage Beach, MOThe pilot not maintaining clearance from the water while maneuvering for photographs.NTSB SEA05LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mountain Home, IDThe pilot's inadequate in-flight decision by failing to refuel resulting in fuel exhaustion during cruise flight and the loss of engine power. A vehicle was a factor in the on ground collision.NTSB SEA05FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Yamhill, ORThe flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…NTSB SEA05CA131Accident · No injuriesData collectionFinal reportMaule M-7-235B · Hermiston, ORThe pilot's failure to maintain directional control during the takeoff ground roll which resulted in overload damage to the main landing gear. During the landing roll, it was not possible to maintain aircraft control due to the previously damaged gear.…NTSB IAD05CA086Accident · Minor injuriesData collectionFinal reportPorterfield CP-65 · Jaffrey, NHThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor in the accident was the drop off/descending embankment at the runway's edge.NTSB DFW05LA175Accident · No injuriesLimited investigationFinal reportNorth American T-28B · Abilene, TXThe pilot's failure to maintain clearance while taxiing. Contributing factors were the pilot's diverted attention and the inaccurate frequency listing for ground control.NTSB DFW05FA170Accident · 5 fatalField investigationFinal reportBeech E90 · New Roads, LAThe pilot's failure to maintain airspeed and subsequent loss of control during a go-around maneuver.NTSB DEN05LA099Accident · No injuriesLimited investigationFinal reportCampbell Long EZ · Santa Fe, NMthe inflight collision with a bird(s).NTSB DEN05CA096Accident · No injuriesData collectionFinal reportAviat A-1B · Dove Creek, COthe pilot's failure to maintain airspeed during initial climb which resulted in an inadvertant stall and impact with terrain.NTSB CHI05CA156Accident · Minor injuriesData collectionFinal reportBell 206L-3 · Algonac, MIThe pilot not maintaining helicopter control, the loss of tail rotor effectiveness he encountered, and his not maintaining clearance from objects during the approach. Factor were the low altitude, the transmission lines, and the garage.NTSB ATL05LA113Accident · 1 fatalLimited investigationFinal reportMize Donald Kolb MK III X · Dickson, TNThe pilot's failure to maintain adequate obstacle clearance during climb out which resulted in the in-flight collision with a tree.NTSB SEA05WA204Accident · No injuriesForeign investigationBell 204B-1 · Yangyang, South KoreaNTSB NYC05LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Edgartown, MAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall and subsequent impact with terrain. [This report was modified on June 10, 2008]NTSB NYC05CA112Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, PAThe student pilot's improper flare, and inadequate recovery from a bounced landing, which resulted in a nose gear collapse while landing.NTSB LAX05LA215Accident · Minor injuriesLimited investigationFinal reportBeech BE76 · Glendale, AZthe flight instructor's decision to attempt a single engine go-around with multiple aircraft system failures, and his improper in-flight decision to pass up one airport for landing and continue the flight to the home base airport with known mechanical…NTSB IAD05LA088Accident · No injuriesLimited investigationFinal reportCessna T206H · Vineland, NJThe pilot's inadequate preflight planning, which resulted in his decision to land at a closed airport.NTSB IAD05LA083Accident · 1 fatalLimited investigationFinal reportTitan Tornado · Bath, PAThe pilot/owner's failure to maintain adequate airspeed following a loss of engine power, which resulted in an inadvertent stall/spin. Factors in the accident were the stripped spark plug threads, and an inadequate preflight inspection by the pilot/owner.NTSB IAD05LA082Accident · No injuriesLimited investigationFinal reportBeech C35 · West Milford, NJThe pilot's failure to maintain directional control during landing, which resulted in a collision with a drainage ditch.NTSB ENG05RA016Incident · No injuriesForeign investigationBoeing 777 · Tokyo, JapanNTSB DFW05LA171Accident · 1 fatalLimited investigationFinal reportCessna A188B · Piggott, ARThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall.NTSB DFW05CA173Accident · No injuriesData collectionFinal reportAyres S-2R · Eagle Lake, TXThe pilot's failure to maintain directional control during landing.NTSB DFW05CA168Accident · No injuriesData collectionFinal reportHughes 269C · Bruceville, TXThe flight instructor's improper flare during autorotation, which resulted in a hard landing. Contributing factor was, the lack of suitable terrain.NTSB CHI05CA155Accident · No injuriesData collectionFinal reportCessna 172 · Willis, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. A factor associated with the accident were the trees that the airplane contacted during the aborted takeoff.NTSB ATL05LA111Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Yadkinville, NCThe pilots failure to maintain adequate clearance from object and inadequate visual look-out while maneuvering resulted in an in-flight collision with power lines.NTSB ATL05LA110Accident · 1 fatalLimited investigationFinal reportCasten Rans S-10 · Perry, SCA loss of engine power due to fuel starvation as a result of the pilot mismanagement. Contributing to the accident was the pilot's failure to maintain adequate airspeed resulting in a stall during the forced landing.NTSB ATL05CA112Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Dunnellon, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB DFW05CA172Accident · Serious injuriesData collectionFinal reportGarlick Helicopters OH-58A+ · Graham, TXThe pilot's failure to maintain clearance with the wire while maneuvering during an aerial application flight. Low altitude flight is a contributing factor.NTSB SEA05FA124Accident · Serious injuriesField investigationFinal reportCessna 320E · Missoula, MTTerrain clearance was not possible as a result of a right engine failure. Factors contributing to the accident included the rising terrain, foreign material being ingested into the engine's turbocharger, which obstructed the turbocharger's impeller, the…NTSB ENG05RA017Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Singapore, SingaporeNTSB DFW05LA167Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Carizzo Springs, TXThe failure of the stabilator trim control rod due to internal corrosion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05CA153Accident · Minor injuriesData collectionFinal reportS C Aerostar S A YAK-52 · Columbus, NEThe mechanic's inadequate installation of fuel lines, the obstruction of fuel lines, and the fuel starvation leading to the non-mechanical loss of engine power during approach and the unsuitable terrain the pilot encountered during the forced landing.NTSB ATL05WA108Accident · No injuriesForeign investigationCessna 525A · Valencia, VenezuelaNTSB SEA05LA121Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Fairview, MTWhile in cruise flight a separation of a propeller blade as a result of a propeller hub crack. Factors contributing to the accident included the installation of an unapproved propeller, and the failure to properly service the propeller with red dyed oil for…NTSB NYC05LA103Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Beverly, MAThe pilot's failure to attain the proper touchdown point while conducting a precautionary landing. A factor was the partial loss of power to one engine for undetermined reasons.NTSB NYC05CA104Accident · No injuriesData collectionFinal reportPiper J3C-65 · Fredericksburg, PAThe pilot's improper engine starting procedures, which resulted in the airplane taxiing unoccupied and impacting a light pole.NTSB IAD05CA081Accident · Minor injuriesData collectionFinal reportPZL Swidnik PW-5 · Bloomingburg, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with terrain.NTSB DFW05LA165Accident · Minor injuriesLimited investigationFinal reportCessna 401A · Houston, TXThe loss of engine power to both engines due to fuel starvation as a result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05IA098Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Salt Lake City, UTthe left wing walker's failure to maintain an adequate visual lookout. Contributing factors were his inadequate initial training, and the failure of other ground personnel to follow company procedures/directives.NTSB ATL05LA105Accident · 1 fatalLimited investigationFinal reportCessna T182T · Naples, FLThe pilot continued flight into known thunderstorm activity that resulted in the loss of control and the subsequent collision with water. A factor was the controller's failure to provide the pilot with convective intensity.NTSB ATL05FAMS1Accident · 3 fatalMissing aircraftFinal reportPiper PA-23 · Ft Pierce, FLThe pilot's continued flight into known thunderstorm activity that resulted in the loss of control and the subsequent collision with water. A factor was the controller's failure to provide the pilot with convective intensity.NTSB SEA05WA130Accident · 2 fatalForeign investigationCessna 172 RG · Dittingen, SwitzerlandNTSB SEA05CA122Accident · Minor injuriesData collectionFinal reportBell 47G-3B-1 · Brewster, WAThe pilot's inadvertent anti-torque pedal input, which resulted in a loss of control and collision with trees while hovering.NTSB SEA05CA119Accident · No injuriesData collectionFinal reportAdkins Ridge Runner II · Pocatello, IDThe pilot's failure to maintain directional control during the takeoff roll, which resulted in an inadvertent ground loop/swerve.NTSB NYC05FA100Accident · 1 fatalField investigationFinal reportCessna 182Q · Stockholm, NJThe pilot's failure to maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the ground. Factors in this accident were clouds, and the pilot's spatial disorientation.NTSB NYC05CA102Accident · Minor injuriesData collectionFinal reportCessna R182 · Hancock, NYThe pilot's misjudgment of speed/distance which resulted in a runway overrun. A factor was the wet turf runway.NTSB LAX05CA212Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Pine Valley, CAThe pilot's delay in aborting the takeoff and excessive brake application. A contributing factor was the downsloping terrain used for the landing and takeoff.NTSB IAD05LA080Accident · 2 fatalLimited investigationFinal reportNavickas Load Runner 2000 · Hammonton, NJThe pilot's inadequate in-flight decision, which resulted in fuel exhaustion and subsequent loss of engine power. A factor was the wooded area, into which, the pilot had to autorotate.NTSB DFW05CA169Accident · No injuriesData collectionFinal reportRobinson R44 · Rayville, LAThe pilot's loss of control following an encounter with loss of tail rotor effectiveness. A contributing factor was the high density altitude.