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 ERA23LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Mattituck, NYThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a hard landing and runway excursion.NTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…NTSB CEN23LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Telluride, COThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB ERA23LA165Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · St. Augustine, FLThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and an impact with a ditch.NTSB CEN23FA142Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Port Allen, LAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions, which resulted in spatial disorientation and the loss of aircraft control.NTSB GAA23WA113Accident · No injuriesClass 5 · ForeignPiper PA34 · Boa Vista, BrazilNTSB ERA23FA164Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Johns Island, SCThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s degraded judgement and…NTSB ERA23FA163Accident · 1 fatalClass 3 · FieldFinal reportLarry F Preiss AR-1 · Gainesville, GAThe pilot's inadequate preflight inspection and his failure to detect water-contaminated fuel that resulted in a loss of engine power and subsequent impact with a wire and terrain during an attempted forced landing.NTSB CEN23LA143Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Hillsboro, MOThe pilot’s failure to maintain clearance from trees during final approach to landing.NTSB WPR23LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Springfield, KYThe pilot’s failure to activate the pitot heat in a timely manner during flight into icing conditions, which resulted in a temporary failure of the flight instruments and a subsequent loss of control.NTSB GAA23WA111Accident · Minor injuriesClass 4 · ForeignPiper PA-34-200T · Conceição do Araguáia, BrazilNTSB DCA23LA232Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas MD-88 · Saltillo, MexicoThe pilot's failure to adequately compensate for a wind shift while on short final approach which resulted in a higher than normal sink rate and a tailstrike.NTSB ANC23FA031Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron 407 · Nuevo, CAThe pilot’s decision to maneuver in a steep bank at a low altitude, which resulted in his failure to maintain clearance with terrain.NTSB ERA23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Travelers Rest, SCMaintenance personnel’s improper servicing of the magneto, which resulted in its accelerated wear, failure, and the total loss of engine power.NTSB ERA23LA161Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-46-350P · St. Augustine, FLThe pilot's inadequate preflight planning, which resulted in a takeoff above the airplane’s maximum gross weight, a CG forward of the limit, and a tailwind component that prevented the airplane from climbing above trees.NTSB GAA23WA110Accident · No injuriesClass 4 · ForeignEmbraer EMB201 · Nova Ubirata, BrazilNTSB GAA23WA106Incident · No injuriesClass 5 · ForeignCessna 172 · Madrid, SpainNTSB ERA23LA198Accident · No injuriesClass 3 · LimitedFinal reportS C Aerostar S A YAK-52 · Toughkenamon, PAThe pilot’s failure to see and avoid powerlines while on approach to land.NTSB ERA23LA179Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18AS-125 · Lakeland, FLThe pilot’s failure to ensure that the landing gear was properly configured for a water landing.NTSB ENG23WA024Incident · No injuriesClass 5 · ForeignAirbus A320 · Kota Kinabalu, MalaysiaNTSB DCA23WA236Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Incheon, South KoreaNTSB DCA23WA223Incident · Minor injuriesClass 5 · ForeignEmbraer 145 · Kumasi, GhanaNTSB DCA23LA221Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Houston, TXThe first officer's failure to maintain the correct airspeed and pitch attitude during landing which resulted in a tailstrike.NTSB WPR23FA137Accident · 1 fatalClass 3 · FieldFinal reportCessna 182S · Alcova, WYThe airplane’s encounter with low level wind shear associated with moderate turbulence, which resulted in a loss of airplane control.NTSB GAA23WA105Accident · No injuriesClass 4 · ForeignPiper PA25 · Corupa, BrazilNTSB ERA23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Cincinnati, OHThe pilot’s failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a parked airplane. Contributing was the marshaller’s improper marshalling techniques.NTSB ERA23LA157Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2A-1 · Livonia, NYThe pilot’s delayed action to arrest the high descent rate during a practice autorotation in tailwind conditions which ultimately resulted in loss of control.NTSB DCA23WA216Incident · No injuriesClass 5 · ForeignDouglas DC8 · Maiquetía, VenezuelaNTSB DCA23LA213Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-224 · Sacramento, CAAn encounter with forecast convective turbulence during climb.NTSB ERA23LA160Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-7-235C · Abbeville, SCA loss of directional control during landing, which resulted in a ground loop and substantial damage to the airplane. The pilot flying could not be determined since both pilots claimed that the other was at the controls during the landing. The flight…NTSB ERA23LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, NCA loss of directional control while landing, which resulted in a runway excursion and impact with a ditch.NTSB CEN23LA141Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Maple Lake, MNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.NTSB CEN23LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oklahoma City, OKThe pilot’s loss of directional control during landing with wind gusts, which resulted in a runway excursion and nose over.NTSB WPR23LA131Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Santa Ynez, CAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel starvation.NTSB WPR23LA130Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander 100-180 · Gordonville, TXA fatigue fracture of the nose landing gear scissor link, which resulted in a separation of the nose landing gear piston assembly.NTSB GAA23WA103Accident · Serious injuriesClass 5 · ForeignCessna 150 · Porto Nacional, TO, BrazilNTSB GAA23WA100Accident · 2 fatalClass 5 · ForeignDiamond DA40 · Gondia, IndiaNTSB WPR23LA133Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Winnemucca, NVThe student pilot’s failure to maintain directional control, and the flight instructor’s delayed remedial action.NTSB WPR23LA132Accident · No injuriesClass 4 · LimitedFinal reportFay David Velocity Elite · Bullhead City, AZThe student pilot’s improper landing during crosswind conditions and the flight instructor’s failure to take remedial action, which resulted in a loss of control.NTSB WPR23LA129Accident · Serious injuriesClass 4 · LimitedFinal reportNavion Navion A · Mesa, AZThe pilot of the Ryan Navion’s failure to maintain visual sight of and clearance from another airplane during a formation flight, which resulted in a mid-air collision.NTSB GAA23WA104Accident · 4 fatalClass 4 · ForeignRobinson R44 · Sao Paulo, BrazilNTSB ERA23LA156Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Shoreham, NYA total loss of engine power for unknown reasons.NTSB CEN23FA139Accident · 1 fatalClass 3 · FieldFinal reportBeech 58P · Lubbock, TXThe pilot’s failure to ensure a proper fuel selector position before takeoff, which resulted in a loss of left engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain airplane control after the loss of left engine…NTSB ANC23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Minto, AKA total loss of engine power for reasons that could not be determined.NTSB ERA23LA166Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Cleveland, TNThe retraction of the landing gear after landing for unknown reasons.NTSB WPR23LA136Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Spanish Fork, UTThe retraction of the main landing gear for undetermined reasons.NTSB ERA23LA151Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35-B33 · Scottsmoor, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion.NTSB CEN23LA135Accident · No injuriesClass 3 · LimitedFinal reportBell Helicopter Textron APT70 · Mineral Wells, TXThe flight crew’s loss of control of the unmanned aircraft due to software limitations. Contributing to the accident was the overly restrictive low voltage threshold limits.NTSB GAA23WA101Accident · Minor injuriesClass 5 · ForeignEmbraer EMB202 · Porto dos Gauchos, MT, BrazilNTSB CEN23LA132Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Hotchkiss, COThe pilot’s loss of control during landing rollout on a snow-covered, turf airstrip.