NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 DCA23LA179Incident · No injuriesClass 3 · LimitedFinal reportBoeing 737-823 · Sarasota, FLThe local controller’s failure to prioritize and properly monitor the runway and airport environment along with his erroneous assumption that ROU 1633 would depart from runway 14 before AAL2172 arrived to land on the same runway, which resulted in a loss of…NTSB CEN23LA112Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Houston, TXThe pilot’s loss of directional control during landing which resulted in a runway excursion. Contributing to the accident was the pilot’s decision to land with a crosswind that exceeded the limitation for the airplane.NTSB WPR23LA112Accident · 1 fatalClass 3 · LimitedFinal reportStar Lite SL1 · Corning, CAThe student pilot’s loss of airplane control during an intentional aerobatic maneuver, which resulted in an inflight separation of the left wing and subsequent impact with the terrain.NTSB GAA23WA079Accident · No injuriesClass 5 · ForeignAMD CH2000 · La Isabela, Dominican RepublicNTSB GAA23WA078Accident · No injuriesClass 5 · ForeignEmbraer EMB201 · Santa Vitoria do Palmar, BrazilNTSB ERA23LA127Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Atlanta, GAThe flight instructor’s failure to effectively utilize carburetor heat, which resulted in a total loss of engine power during initial climb due to carburetor ice that formed during the engine run-up and taxi.NTSB DCA23LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A319-132 · New Orleans, LAThe flight’s encounter with convective turbulence.NTSB WPR23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Fullerton, CAThe student pilot's failure to maintain control of the airplane during the landing roll and the flight instructor’s delayed remedial action, which resulted in an impact with an obstacle.NTSB ERA23LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Keystone Heights, FLThe pilot’s improper decision to perform an impromptu off-airport landing and his failure to maintain control of the airplane during the landing, which resulted in a nose-over.NTSB CEN23LA115Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Cahokia, ILThe pilot’s failure to extent the landing gear before landing.NTSB GAA23WA124Incident · No injuriesClass 5 · ForeignPiper PA28 · Malacca City, MalaysiaNTSB ANC23LA023Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P337H · Kona, HIThe failure of the pilot to recognize that the rear engine was not operating during takeoff, which resulted in an attempted single-engine takeoff and the airplane’s subsequent descent and impact with terrain. Contributing to the accident was a loss of rear…NTSB ANC23LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Chugiak, AKThe pilot’s failure to maintain directional control during takeoff in flat light conditions which resulted in a loss of control and impact with a snow berm.NTSB GAA23WA071Accident · 3 fatalClass 5 · ForeignCessna 172H · San Francisco, GuatemalaNTSB DCA23WA177OccurrenceClass 5 · ForeignBoeing 777 · Istanbul, TürkiyeNTSB WPR23LA109Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Morgan, UTThe pilot’s failure to maintain directional control during landing.NTSB ENG23WA020IncidentClass 5 · ForeignATR ATR72 · Fa'a'a, French PolynesiaNTSB CEN23LA108Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Crosby, TXThe pilot’s delayed soft-field takeoff procedure, which prevented the pilot from achieving adequate airspeed and a proper climb rate resulting in a collision with a moving train.NTSB CEN23LA107Accident · No injuriesClass 3 · LimitedFinal reportMooney M20 · Lakeway, TXA total loss of engine power due to detonation and preignition in the No. 6 cylinder.NTSB ERA23LA126Accident · No injuriesClass 3 · LimitedFinal reportGates Learjet 55 · Rochester, NYThe pilots’ failure to attain a proper landing flare and touchdown point, which resulted in a hard landing short of the runway.NTSB DCA23LA170Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Rushville, INAn encounter with clear air turbulence during descent.NTSB CEN23LA106Accident · No injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Cortland, ILA total loss of engine power for reasons that could not be determined.NTSB ANC23LA021Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Tok, AKThe pilot's failure to maintain a proper approach glide path, which resulted in a hard landing, short of his anticipated touchdown point.NTSB GAA23WA099Accident · No injuriesClass 5 · ForeignCessna 208B · Puente de Ixtla, MexicoNTSB DCA23WA178IncidentClass 5 · ForeignBoeing 737 · Paris, FranceNTSB DCA23WA166OccurrenceClass 5 · ForeignBoeing 767-332 · Prestwick, United KingdomNTSB DCA23LA477Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Lake Butler, FLAn inadvertent encounter with convectively induced turbulence.NTSB GAA23WA072Accident · 2 fatalClass 4 · ForeignRobinson R44 · Vargem Alta, BrazilNTSB ENG23WA018IncidentClass 5 · ForeignAirbus A321 · Guadalajara, MexicoNTSB DCA23WA165OccurrenceClass 5 · ForeignBoeing 777 · Mediterranean Sea, NetherlandsNTSB ANC23LA020Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-16 · Soldotna, AKA total loss of engine power for undetermined reasons.NTSB GAA23WA069Incident · No injuriesClass 5 · ForeignPiper PA-23-250 · Nassau, BahamasNTSB DCA23WA159Incident · No injuriesClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaNTSB CEN23LA104Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SF50 · Waukesha, WIThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident was the pilot’s inadequate preflight inspection removal of the angle of attack vane cover.NTSB WPR23LA108Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Lander, WYThe pilot’s failure to maintain directional control during landing.NTSB WPR23LA107Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH-58A · Yuma, AZA total loss of engine power for reasons that could not be determined.NTSB WPR23LA105Accident · No injuriesClass 4 · LimitedFinal reportHughes 269C · Yakima, WAThe pilot's failure to see and avoid a powerline while flying at low altitude over a river.NTSB ERA23LA140Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Lake Katrine, NYThe pilot’s failure to maintain an appropriate pitch attitude and descent rate during landing, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB ERA23LA125Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Pikeville, NCThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA23LA124Accident · Serious injuriesClass 3 · LimitedFinal reportCanton Paul A RV-6 · Milton, FLThe incorrect installation of the fuel pickups, which resulted in a total loss of engine power due to fuel starvation. Contributing was the lack of documentation of the airplane’s unusable fuel.NTSB DCA23WA150Accident · Minor injuriesClass 5 · ForeignBoeing 737-3H4 · Womarden, AustraliaNTSB CEN23LA133Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Hilbert, WIThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23LA103Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 425 · Bismarck, NDA loss of braking due to inadequate servicing of brake fluid by the pilot/mechanic, which resulted in a loss of airplane control on the ground.NTSB WPR23LA104Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Gladewater, TXThe loss of engine power for undetermined reasons.NTSB GAA23WA070Accident · No injuriesClass 5 · ForeignLearjet 60 · North Eleuthera, BahamasNTSB ENG23WA021Incident · No injuriesClass 4 · ForeignSikorsky S-92 · Derry, United KingdomNTSB ENG23WA019IncidentClass 5 · ForeignAirbus A320 · Amritsar, IndiaNTSB CEN23LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe student pilot’s failure to maintain directional control during a touch-and-go landing.NTSB CEN23LA099Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-160 · Eau Claire, WIThe engine fire that began for undetermined reasons following numerous engine start attempts.NTSB WPR23LA103Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Porterville, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.