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 CHI06FA110Accident · 1 fatalField investigationFinal reportMesserschmitt-Bolkow-Blohm BO 105LS A-3 · Green Bay, WIThe pilot's inadequate preflight check of the flight controls prior to takeoff and the directional contol not possible by the pilot. Additional causes were the improper installation of the anti-torque pedal cover by company personnel which blocked the flight…NTSB CHI06FA109Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Chelsea, MIThe pilot's inadequate preflight inspection of the helicopter that failed to discover water in the fuel, resulting in a loss of engine power while maneuvering, and an in-flight collision with trees and terrain. Factors associated with the accident were…NTSB CHI06CA111Accident · No injuriesData collectionFinal reportLee SQ 2000 · Berrien Springs, MIFailure of the right main landing gear assembly during landing and the pilot's subsequent inability to maintain directional control of the airplane. Contributing factors were the collapse of the left and right main landing gear and the gusty, crosswind…NTSB MIA06WA087Accident · 2 fatalForeign investigationPiper PA-34-200T · Antioquia, ColombiaNTSB MIA06LA086Accident · No injuriesLimited investigationFinal reportCessna 310K · Brooksville, FLThe mechanic's improper maintenance that resulted in the right main landing gear's separation from the airplane and an inadvertent loss of control during landing.NTSB LAX06LA141Accident · 1 fatalLimited investigationFinal reportVelocity XL-RG · Pearce, AZa departure from controlled flight for undetermined reasons, resulting in a collision with terrain.NTSB LAX06CA142Accident · No injuriesData collectionFinal reportAir Tractor 502A · Stanfield, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll.NTSB DEN06LA061Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Smith Center, KSthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush, and subsequent impact with the field and fence. A factor contributing to the accident was the pilot's inadequate flight planning and preparation.NTSB DEN06CA066Incident · No injuriesData collectionFinal reportCessna 170A · Buena Vista, COThe pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the crosswinds and the wind gusts.NTSB CHI06CA114Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Drayton, NDThe pilot's failure to maintain directional control during takeoff. A related factor was the high wind condition.NTSB ATL06CA064Accident · Minor injuriesData collectionFinal reportCessna L-19 · Kenly, NCThe pilot's continued operation of the airplane with known deficiencies (tail wheel steering) which resulted in loss of directional control during the takeoff roll, and a ground loop.NTSB ATL06CA063Accident · No injuriesData collectionFinal reportCessna 0-1A · Kenansville, NCThe pilot's failure to maintain directional control which resulted in an ground loop, and subsequent collision with ground.NTSB NYC06LA092Accident · Minor injuriesLimited investigationFinal reportMichaud KR2S · North Andover, MAA partial loss of engine power for undetermined reasons, during the initial climb, which resulted in a forced landing into trees.NTSB NYC06CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout.NTSB DFW06WA099Accident · Serious injuriesForeign investigationBell 407 · Morelia, MexicoNTSB DEN06LA059Accident · No injuriesLimited investigationFinal reportCessna TR182 · Fort Collins, COthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's improper preflight planning, the pilot's failure to refuel the airplane, and the lack of suitable terrain for the forced landing.NTSB DEN06LA058Accident · No injuriesLimited investigationFinal reportEldredge NXT · Glenwood, NMthe loss of engine power due to the partial failure of the crankcase nose seal for undetermined reasons. A contributing factor was the pilot's diminished visibility during the forced landing due to oil on the windscreen, resulting in a runway excursion and…NTSB DEN06CA060Accident · Minor injuriesData collectionFinal reportAir Tractor AT-602 · Ulysses, KSthe loss of engine power due to fuel starvation. A contributing factor was the impact with a ditch during the forced landing.NTSB SEA06CA073Accident · No injuriesData collectionFinal reportCessna 170B · Havre, MTThe pilot's improper starting procedures in attempting to hand-prop the airplane's engine. Contributing factors were the discharged battery, the failure of the right parking brake and the hangar which the aircraft collided with.NTSB NYC06LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Passadumkeag, METhe partially blocked fuel line, which resulted in fuel starvation and a subsequent loss of engine power. Factors in the accident included inadequate maintenance, and the unsuitable terrain.NTSB CHI06CA108Accident · No injuriesData collectionFinal reportCessna 182 RG · Fort Wayne, INThe pilot failed to lower the landing gear prior to landing.NTSB CHI06CA107Accident · No injuriesData collectionFinal reportCessna 150 · Sandstone, MNThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A contributing factor was the unsuitable terrain encountered during the forced landing.NTSB ATL06CA062Accident · No injuriesData collectionFinal reportCessna C-172S · Sanford, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB NYC06WA095Accident · Minor injuriesForeign investigationBell 206 · Propriano, FranceNTSB NYC06LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Philadelphia, PAA fatigue failure of the number 3 cylinder attachment studs, which resulted in a loss of engine power and subsequent forced landing.NTSB DFW06CA098Accident · No injuriesData collectionFinal reportCessna 172S · Denton, TXThe student pilot's failure to maintain directional control during the takeoff roll.NTSB CHI06CA144Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Logansport, INThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB SEA06CA072Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Tooele, UTThe pilot's failure to maintain control of the helicopter during the takeoff initial climb, which resulted in an in-flight collision with the ground. A contributing factor was the gusty wind condition.NTSB MIA06CA084Accident · No injuriesData collectionFinal reportLinwood R. Lawrence Van's Aircraft RV-9A · Venice, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.NTSB LAX06CA272Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Coalinga, CAthe pilot's misjudged landing flare, which resulted in a bounced landing, and his inadequate recovery technique that led to a hard landing.NTSB CHI06CA113Accident · No injuriesData collectionFinal reportCessna 195 · Pine Creek, MNThe pilot's improper flare and improper recovery from a bounced landing.NTSB SEA06TA071Accident · No injuriesFinal reportBell 206B · Sprague, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering. Mountainous terrain was a factor.NTSB NYC06LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Norfolk, VAThe pilot's failure to maintain aircraft control during a single-engine go-around. A factor was the partial loss of engine power.NTSB MIA06CA085Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Tallahassee, FLThe pilot's failure to maintain directional control during the landing rollout while making a crosswind landing in gusting conditions which resulted in an advertent ground loop and damage to the airplane.NTSB MIA06CA083Accident · No injuriesData collectionFinal reportCessna 172M · Vero Beach, FLThe pilot's failure to maintain directional control while executing a go-around in gusty conditions which resulted in the airplane veering off the runway, colliding with a ditch and nosing over.NTSB MIA06CA082Accident · No injuriesData collectionFinal reportCessna C170A · Lakeland, FLThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB DFW06LA101Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Kerrville, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA097Accident · Serious injuriesLimited investigationFinal reportRocket Flyers Turbine Legend · Hammond, LAThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA096Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Lakeview, ARThe pilot's inadequate weather evaluation and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.NTSB CHI06LA105Accident · 1 fatalLimited investigationFinal reportCessna 177 · Blackburn, MOThe pilot's failure to maintain obstacle clearance from the power line during low altitude maneuvering. A factor was the power line.NTSB ATL06CA066Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Shelbyville, TNThe pilot's inadequate in-flight planning/decision which resulted in a total loss of engine power due to fuel exhaustion.NTSB NYC06CA088Accident · No injuriesData collectionFinal reportCessna 172-P · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB MIA06CA081Accident · No injuriesData collectionFinal reportWoolley John A Lancair 320 · Lakeland, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.NTSB MIA06CA080Accident · Minor injuriesData collectionFinal reportAero Commander 100 · Englewood, FLThe pilot's failure to abort the takeoff in time to stop on the remaining runway, which resulted in the airplane overrunning the runway.NTSB LAX06CA137Accident · No injuriesData collectionFinal reportCessna 170A · Hanford, CAthe pilot's failure to maintain directional control.NTSB LAX06CA136Accident · No injuriesData collectionFinal reportCessna 172 · Wickenburg, AZthe pilot's failure to maintain directional control.NTSB ANC06LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350BA · Haines, AKThe pilot's failure to maintain adequate clearance from an object while landing a helicopter at a remote site, which resulted in the main rotor blades striking a tree.NTSB MIA06CA079Accident · No injuriesData collectionFinal reportMooney M20R · Destin, FLThe pilot's failure to maintain airspeed while attempting a go-around at a low altitude which resulted in an inadvertent stall/mush, an uncontrolled descent and an impact with terrain.NTSB DFW06FA095Accident · 2 fatalField investigationFinal reportPiper/Stevens PA18A-150 · Hollandale, MSThe pilots failure to maintain control of the airplane. A contributing factor was the pilots impairment.NTSB DEN06WA057Accident · 1 fatalForeign investigationHerde Lancair 360 · Bankstown, Australia