NTSB investigations, 2005
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 year(c.\"eventDate\") = 2005 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 year(c."eventDate") = 2005 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 NYC06FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Leesburg, VAThe flight instructor's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with trees and terrain.NTSB DFW06CA030Accident · No injuriesData collectionFinal reportCessna 172N · Arlington, TXThe students improper recovery from a bounced landing. A contributing factor was the pilots excessive airspeed on final approach.NTSB DCA06WA003Incident · No injuriesForeign investigationBoeing 737-7Q8 · Melbourne, AustraliaNTSB NYC06LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Lehighton, PAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during takeoff due to fuel contamination, and a subsequent forced landing to a field.NTSB NYC06FA027Accident · Serious injuriesField investigationFinal reportEmbraer 110P1 · Manchester, NHThe pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…NTSB LAX06LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Mesa, AZthe failure of the flap motor fuse that rendered the flaps inoperable during a critical phase of flight. Factors in the accident were the lack of suitable terrain to perform an emergency landing and the owner's use of nonapproved fuses for the flap motor…NTSB DEN06FA013Accident · 1 fatalField investigationFinal reportBeech A36 · Datil, NMthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.NTSB CHI06LA027Accident · No injuriesLimited investigationFinal reportAgusta A109-E · Robbinsdale, MNThe loss of lift for undetermined reasons.NTSB CHI06FA026Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ankeny, IAThe pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…NTSB MIA06WA020Incident · No injuriesForeign investigationCessna 172M · Essequibo Coast, GuyanaNTSB LAX06CA026Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Payson, AZa loss of engine power due to fuel exhaustion, which was caused by the pilot's inadequate preflight and in-flight planning, his inadequate fuel consumption calculations, and his failure to divert to an alternate airport before the fuel situation became…NTSB DEN06CA012Accident · No injuriesData collectionFinal reportKucklick Hiperbipe · Watkins, COthe pilot's failure to maintain aircraft control during the landing resulting in a impact with a runway light and ground loop.NTSB DCA06WA004Accident · No injuriesForeign investigationBoeing 234 · Taitung, TaiwanNTSB ATL06CA118Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe student pilot's failure to maintain airspeed during a touch-and-go landing on initial takeoff climb, resulting in a hard landing on the departure runway.NTSB ATL06CA013Accident · Minor injuriesData collectionFinal reportBeech BE-76 · Greer, SCThe pilot's misjudgment of altitude and distance which resulted in an undershoot of the runway, and the collision with trees.NTSB MIA06LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Opa-Locka, FLThe failure of the pilot-in-command/CFI to maintain control of the airplane and his inattentiveness to the altitude while troubleshooting the landing gear system resulting in the in-flight collision with terrain.NTSB DFW06FA021Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Tomball, TXThe pilot's failure to maintain control of the aircraft while attempting to execute a missed approach procedure in weather that was below landing minimums. Contributing factors were the low ceiling, and the below approach landing minimums.NTSB DFW06CA026Accident · No injuriesData collectionFinal reportCessna 172N · Sherman, TXThe pilot's failure to maintain directional control during takeoff.NTSB DFW06CA022Accident · No injuriesData collectionFinal reportPiper PA38 · Decatur, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA06WA008Accident · No injuriesForeign investigationBoeing B-777 · Heathrow IAP, United KingdomNTSB DCA06WA006Incident · No injuriesForeign investigationBoeing 767-200 · London, United KingdomNTSB CHI06CA028Accident · No injuriesData collectionFinal reportCessna 182 · Butler, MOThe damage to the horizontal stabilizer was a result of the inadvertent deployment of the skydiver's reserve parachute.NTSB NYC06LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Laurel, DEThe pilot's improper decision to takeoff from an unimproved field, and his subsequent failure to abort the takeoff prior to collision with a sign and an embankment. Factors in the accident were his improper soft field technique, and the dark night conditions.NTSB NYC06FA025Accident · 1 fatalField investigationFinal reportCessna 172A · Pohatcong, NJThe inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.NTSB DFW06LA027Accident · 1 fatalLimited investigationFinal reportArrow Falcon Exporters Arrow F OH-58A · West Memphis, ARThe loss of engine power due to a disconnected pneumatic (Pc) line. A contributing factor was the ravine.NTSB DFW06FA019Accident · 2 fatalField investigationFinal reportCessna 500 · Houston, TXThe pilot's failure to maintain directional control of the airplane resulting in an inadvertent stall/mush. Contributing factors were the unsecured passenger door and the pilot's diverted attention.NTSB DFW06CA020Accident · Minor injuriesData collectionFinal reportDeussen Alexander II Rotorway Exec · Gibson, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA029Accident · No injuriesData collectionFinal reportHughes 269A · Omaha, NEThe loss of engine power for an undetermined reason and the pilot's improper execution of the emergency procedure which resulted in an excessive descent rate and subsequent hard landing.NTSB ATL06CA018Accident · No injuriesData collectionFinal reportCessna 152 · Durham, NCThe pilot's improper flare on landing flare touchdown resulting in a hard landing and collapse of the nose gear.NTSB ATL06CA012Accident · No injuriesData collectionFinal reportCessna 150 · Monroesville, ALThe pilot's failure to maintain directional control, which resulted in a loss of control and collision with trees.NTSB ANC06TA009Accident · Minor injuriesFinal reportCessna 185 · Cordova, AKA fracture and separation of the main landing gear strut during the landing roll, which resulted in a loss of control, and subsequent nose down. Factors contributing to the accident were the manufacturer's and the FAA's insufficient standards/requirements…NTSB MIA06WA016Accident · 1 fatalForeign investigationBeech 95-55 · Porlamar, VenezuelaNTSB LAX06CA027Accident · No injuriesData collectionFinal reportLee Kolb Mark III Classic · Tucson, AZthe fatigue failure of the attachment that secured the horizontal stabilizer to the fuselage.NTSB LAX06CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Torrance, CAthe pilot's excessive taxi speed, and his failure to maintain an adequate clearance from objects.NTSB SEA06WA016Accident · 2 fatalForeign investigationBoeing Vertol BV-107 II · Bella Bella, CanadaNTSB SEA06CA018Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Tacoma, WAThe collapse of the landing gear due to the pilot's failure to use the emergency gear extension system after his aircraft experienced a complete loss of electrical power. Factors include the malfunction of the voltage regulating system, which lead to the…NTSB MIA06WA017Incident · No injuriesForeign investigationCessna 172M · Timehri, GuyanaNTSB LAX06LA024Accident · Serious injuriesLimited investigationFinal reportSchleicher ASH 26 E · Sparks, NVThe pilot's inadvertent flight into instrument meteorological conditions which resulted in a subsequent loss of control and an in-flight breakup. A contributing factor was the spool up delay for the emergency turn and bank indicator.NTSB DFW06WA023Accident · 2 fatalForeign investigationBell 206 · El Marques, MexicoNTSB DFW06CA018Accident · No injuriesData collectionFinal reportPiper PA28A · Lubbock, TXThe pilot's inability to maintain directional control of the airplane while landing due to the separation of the nose landing gear tire assembly.NTSB CHI06CA025Accident · Minor injuriesData collectionFinal reportPiper PA22-150 · Canton, ILThe fire for undetermined reasons.NTSB NYC06CA020Accident · Minor injuriesData collectionFinal reportRobinson R44 · Bourne, MAThe inadvertent contact of a lift strap with the tail rotor during external load operations, which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the gusty wind conditions.NTSB MIA06CA014Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilots inadequate landing flare/touchdown which resulted in a hard landing.NTSB NYC06LA024Accident · Minor injuriesLimited investigationFinal reportLo-N-Slo Airsports Maxair Drifter XP-50 · Cobbs Creek, VAFailure of the ignition system, which resulted in a loss of engine power.NTSB NYC06CA021Accident · Serious injuriesData collectionFinal reportCraig Sonerai II LT · Ashland, KYA loss of directional control during an emergency landing. A factor in the accident was an unlatched canopy requiring the pilot to hold it closed to maintain aircraft control.NTSB LAX06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lodi, CAa loss of engine power for undetermined reasons. A factor was the trees.NTSB ATL06CA010Accident · Minor injuriesData collectionFinal reportRobinson Beta II · Lawrenceville, GAThe pilot's improper use of flight controls which resulted in a collision with a fence.NTSB NYC06CA022Accident · Serious injuriesData collectionFinal reportCameron Balloons O-90 · Bethlehem Twp., NJThe ground crewmember's inadvertent entanglement in the balloon's vent lines.NTSB LAX06CA039Accident · No injuriesData collectionFinal reportCessna 182T · Livermore, CAsubstantial damage to the airplane during unknown phase of flight for undetermined reasons.NTSB DCA06WA001Incident · No injuriesForeign investigationBoeing 737-900 · Calgary, Canada