NTSB investigations, TX
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 WHERE c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA' 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 WHERE c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' 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 FTW02FA004Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Alvarado, TXThe inadvertent flat spin of the airplane by the flightcrew resulting from the flight instructor's inadequate supervision. A contributing factor was the impairment (drugs) of the private pilot.NTSB FTW02FA003Accident · No injuriesField investigationFinal reportFokker F28 Mk 0100 · DFW Airport, TXThe collapse of the nose landing gear as a result of the failure of company maintenance personnel to follow the proper procedures for a towing the airplane with an unsafe nose landing gear indication. Contributing factors were the inadequate communication…NTSB FTW02LA001Accident · No injuriesLimited investigationFinal reportBeech M35 · Denton, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA212Accident · No injuriesLimited investigationFinal reportBeech 70 · College Station, TXthe loss of right engine power during takeoff initial climb for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA213Accident · Serious injuriesLimited investigationFinal reportCameron Balloon N-77 · McKinney, TXthe pilot's failure to maintain clearance with the fence while landing. A contributing factor was the high wind condition.NTSB FTW01LA211Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL M18B · Plainview, TXthe pilot's failure to maintain clearance from the stand pipe while maneuvering during aerial application.NTSB FTW01LA210Accident · No injuriesLimited investigationFinal reportCessna T188C · Aiken, TXthe application of silicon sealant to the crankcase mating surfaces by maintenance personnel, which resulted in improper torque on the bolts which mate the crankcase halves, vibration, and the subsequent failure of the #2 main crankshaft bearing. A factor was…NTSB FTW01LA208Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Waco, TXthe mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent engine failure during takeoff climb. A contributing factor was the lack of…NTSB FTW01LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eagle Lake, TXthe partial loss of engine power for an undetermined reason, which resulted in an in flight collision with trees and terrain.NTSB FTW01LA207Accident · No injuriesLimited investigationFinal reportAyres S2R-T11 · Spur, TXthe loss of engine power while in cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA205Accident · No injuriesLimited investigationFinal reportHughes 269-C · Lubbock, TXThe loss of engine power while maneuvering for undetermined reasons. A contributing factor was a malfunction of the spray system.NTSB FTW01LA202Accident · Minor injuriesLimited investigationFinal reportHiller UH-12D · Lubbock, TXthe failure of the tail rotor drive shaft hanger bearing, which resulted in the separation of the tail rotor drive shaft. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01TA194Accident · Minor injuriesFinal reportPiper PA-18-150 · Van Horn, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to the accident was the high density altitude.NTSB FTW01LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-46-310P · Bulverde, TXthe pilot's failure to obtain airspeed after rotation, which resulted in a stall/mush. Contributing factors were the tailwind condition, high density altitude, and upsloping runway.NTSB FTW01FA188Accident · 1 fatalField investigationFinal reportCessna 152 · Weatherford, TXThe student pilot's improper decision making in that he landed with a tailwind and failed to execute a go-around, which resulted in a runway overrun. Contributing factors were the inaccurate reading of the left fuel gage as a result of improper maintenance by…NTSB FTW01LA187Accident · Serious injuriesLimited investigationFinal reportBeech F33C · Sugarland, TXthe pilot's inadvertent stall of the airplane during the base/final approach for landing which resulted in a collision with terrain. A contributing factor was the pilot's diverted attention to an open cockpit door.NTSB FTW01LA185Accident · Minor injuriesLimited investigationFinal reportBeech A-36TC · Fort Worth, TXthe partial loss of engine power for an undetermined reason and the pilot's decision to initiate the takeoff downwind.NTSB FTW01LA200Accident · No injuriesLimited investigationFinal reportCessna 182A · Salado, TXA loss of engine power for undetermined reasons. A factor was the pilot's failure to maintain airspeed during the forced landing resulting in a stall. This report was modified on December 2, 2005.NTSB FTW01LA186Accident · No injuriesLimited investigationFinal reportCessna 421B · New Braunfels, TXthe pilot's inadequate flare of the airplane resulting in a hard landing. A contributing factor was the crosswind.NTSB FTW01LA184Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fabens, TXthe pilot's inadequate preflight resulting in loss of engine power due to fuel exhaustion. A contributing factor was the power line.NTSB FTW01IA183Incident · No injuriesIncident investigationFinal reportBoeing 737-347 · DFW Airport, TXThe local controller clearing the taxiing aircraft to cross the runway in front of the aircraft on takeoff roll. Contributing factors were the local controller's failure to follow FAA procedures and directives to visually scan the runway prior to issuing the…NTSB FTW01LA179Accident · 1 fatalLimited investigationFinal reportPdps PZL-Bielsko SZD-55-1 · Uvalde, TXthe pilot's failure to maintain aircraft control during the base turn, which resulted in an inadvertant stall/spin.NTSB FTW01LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Terrell, TXthe flying pilot's failure to maintain control of the airplane during the landing flare which resulted in a hard landing. A contributing factor was the wind shear weather condition.NTSB FTW01LA182Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · San Antonio, TXthe loss of engine power while maneuvering for undetermined reasons.NTSB FTW01LA181Accident · No injuriesLimited investigationFinal reportZacharius Acroduster I · Conroe, TXthe mechanic's inadequate inspection which resulted in the undetected corroded rudder cable and its subsequent failure during aerobatic maneuvers.NTSB FTW01LA201Accident · No injuriesLimited investigationFinal reportCessna 182L · Porter, TXthe pilot's improper recovery from a bounced landing.NTSB FTW01LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Denison, TXthe pilot's delay in aborting the takeoff, which resulted in a runway overrun.NTSB FTW01LA168Accident · 1 fatalLimited investigationFinal reportSchnitz FIIC-2 Goshawk · Marion, TXthe loss of control on takeoff for undetermined reasons.NTSB FTW01LA170Accident · No injuriesLimited investigationFinal reportCessna T210N · Amarillo, TXthe pilot's failure to verify that the landing gear was extended and locked before landing. A contributing factor was a tripped landing gear motor circuit breaker, which resulted in the failure of the main landing gear to fully extend and lock.NTSB FTW01LA166Accident · Serious injuriesLimited investigationFinal reportEurocopter BK117-C1 · Decatur, TXthe pilot's failure to follow the checklist and turn on the fuel transfer pumps, which resulted in fuel starvation and a dual loss of engine power while in cruise flight.NTSB FTW01LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bridgeport, TXthe non-certificated pilot's improper flare which resulted in a hard landing.NTSB FTW01LA164Accident · Minor injuriesLimited investigationFinal reportYoung RV-6 · Spring, TXthe loss of engine power for undetermined reasons during the landing approach. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA169Accident · Serious injuriesLimited investigationFinal reportClark CGS Hawk · Bullard, TXthe pilot's failure to maintain clearance with power lines during low level maneuvers.NTSB FTW01LA162Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Caldwell, TXthe solo student pilot's intentional engine shutdown, while practicing emergency landing prodecures. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mount Pleasant, TXthe pilot's inadvertent ground loop during the landing roll. A contributing factor was his lack of total experience in tail wheel-equipped airplanes.NTSB FTW01LA159Accident · No injuriesLimited investigationFinal reportGlover RV-8 · Mineral Wells, TXthe jammed elevator control stick on takeoff roll. A contributory factor was the crosswind.NTSB FTW01LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Gladewater, TXthe pilot's inadvertent visual flight into instrument meteorological conditions while maneuvering, which resulted in her spatial disorientation and subsequent loss of control of the airplane.NTSB FTW01LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Uvalde, TXThe pilot's failure to verify the landing gear was down and locked, which resulted in a wheels up landing and subsequent ground fire.NTSB FTW01LA156Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Sabinal, TXa loss of engine power due to a crack in the #9 cylinder, which result in the failure of the connecting rod during the aerial application flight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA155Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Paris, TXthe excessive pull up by the passenger along with the certified flight instructor's inadequate supervision leading to a loss of control during the takeoff initial climb.NTSB FTW01LA154Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Celina, TXthe unsuitable landing area selected by the pilot-in-command which resulted in a hard landing. A contributing factor was the uneven/rough terrain.NTSB FTW01LA153Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Houston, TXthe loss of engine power for an undetermined reason, which resulted in a collision with terrain.NTSB FTW01LA150Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Winnsboro, TXthe loss of engine power during takeoff climb for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB FTW01LA149Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Paris, TXthe loss of engine power for an undertermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA144Accident · No injuriesLimited investigationFinal reportCessna 182A · Baytown, TXThe unqualified person's failure to maintain clearance with the power lines while maneuvering. A factor was the dark night light conditions.NTSB FTW01LA142Accident · No injuriesLimited investigationFinal reportCessna 340A · Lancaster, TXA loss of engine power for undetermined reasons. Contributing to the accident was the collapse of the landing gear for undetermined reasons.NTSB FTW01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Magnolia, TXthe pilot's failure to maintain clearance over the wires while on final approach.NTSB FTW01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Amarillo, TXthe pilot's inadequate compensation for the crosswind, which resulted in a hard landing. A contributing factor was the crosswind.NTSB FTW01LA134Accident · No injuriesLimited investigationFinal reportCessna 182K · Victoria, TXthe pilot's inadequate preflight inspection which resulted in an unsecured seat which slipped aft on takeoff.NTSB FTW01LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Georgetown, TXthe pilot's failure to refuel the aircraft resulting in fuel exhaustion during cruise flight. A contributing factor was the gusty wind encountered during the forced landing.