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 FTW96LA117Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lubbock, TXthe pilot's delay in aborting the takeoff.NTSB SEA96LA057Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Puyallup, WAthe owner's failure to comply with requirements for annual inspections of the airplane, and the debonding of the right brake lining and subsequent jamming of the lining into the right main wheel.NTSB CHI96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Warren, MNthe dual student's failure to maintain a proper glidepath and inadequate supervision by the instructor.NTSB ATL96TA047Accident · Minor injuriesFinal reportPiper PA-32-300 · Windermere, FLthe use of improper connecting rod bolts, failure of the overhaul facility to record the correct overhaul date on the work orders for the stored connecting rod assemblies, and subsequent failure of the connecting rod bolts.NTSB SEA96LA052Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Hubbard, ORthe pilot's misjudgment of altitude and distance on short final. A factor was the wet and soft terrain short of the runway threshold.NTSB NYC96LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Butler, PAthe pilot's inadequate compensation for wind conditions during the final approach, which resulted in the uncontrolled descent and subsequent collision with the ground. A contributing factor is windshear conditions.NTSB MIA96WA079Accident · 11 fatalForeign investigationAerospace Tech. of Australia N24A · Port-Au-Prince, HaitiNTSB ATL96LA046Accident · Minor injuriesLimited investigationFinal reportNorth American P-51D · Palm City, FLAn improperly adjusted carburetor which resulted in fuel starvation.NTSB MIA96FA078Accident · 3 fatalField investigationFinal reportAero Commander 500S · Manati, PRFailure of the flight crew, for undetermined reasons, to recover from a stall and resulting uncontrolled descent. This resulted in the aircraft colliding with the terrain while in a 45-60 degree nose down attitude at a slow speed.NTSB FTW96LA116Accident · No injuriesLimited investigationFinal reportCessna 172K · Hedley, TXthe failure of maintenance personnel to properly torque the connecting rod bolts. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96LA054Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ashland, ORthe dual student's improper touchdown, and the instructor's delayed remedial action. The crosswind was a related factor.NTSB NYC96FA061Accident · 1 fatalField investigationFinal reportCessna P206A · Forks Township, PAThe pilot's failure to maintain a proper altitude, and insufficient obstruction lighting requirements established by the Federal Aviation Administration and the Federal Communications Commission.NTSB LAX96LA110Accident · Serious injuriesLimited investigationFinal reportStolp Starduster II · Kahului, HIa faulty engine magneto, and decision by the pilot-in-command to operate the airplane with known deficiencies. A factor relating to the accident was: the airplane was overdue for an annual inspection.NTSB FTW96LA114Accident · No injuriesLimited investigationFinal reportMooney M20M · Alpine, TXThe pilot's failure to maintain airspeed during a misjudged landing flare resulting in a hard landing.NTSB FTW96FA136Accident · 2 fatalField investigationFinal reportMbb BO-105 · Gulf Of MexicoThe pilot's failure to maintain clearance from the ocean for unknown reasons.NTSB FTW96FA113Accident · 1 fatalField investigationFinal reportCessna 150 · Galveston, TXthe pilot's inadvertent flight into instrument meteorological conditions (IMC), and his failure to sufficient altitude. Factors relating to the accident were: darkness, foggy weather conditions, the pilot's lack of instrument experience, his lack of recent…NTSB CHI96FA088Accident · 1 fatalField investigationFinal reportBell 206B-III · Pellston, MIflight into known adverse weather conditions (fog) at too low an altitude by the pilot. Factors associated with this accident were inadequate preflight planning and an improper inflight decision by the pilot when he chose to continue flight into the fog…NTSB SEA96LA051Accident · No injuriesLimited investigationFinal reportMadorin Kitfox III · Grantsville, UTthe pilot's selection of an unsuitable area for a precautionary landing. A factor was the snow covered terrain.NTSB MIA96LA077Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Winter Haven, FLFailure of the pilot to maintain control of the aircraft after initiating a go-around, which resulted in the right wing contacting the ground. The unfavorable wind condition was a related factor.NTSB LAX96LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAthe student pilot's improper use of the rudder control and resultant failure to maintain directional control of the airplane during the landing rollout. Factors relating to the accident were: the student allowed the airspeed to be excessive during the…NTSB FTW96LA115Accident · No injuriesLimited investigationFinal reportCessna 172G · Gunnison, COLoss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB MIA96LA076Accident · No injuriesLimited investigationFinal reportCessna 310L · Auburn, ALan overstress failure of the left main gear side brace lock end fitting for undetermined reasons.NTSB MIA96LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Boca Raton, FLthe partial loss of engine power due to the fatigue failure of the number 3 cylinder hold down studs and nut. A factor was the pilot'e evasive maneuver to avoid golphers on a golf course.NTSB LAX96FA108Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Ramona, CAinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see and avoid each other.NTSB FTW96LA112Accident · No injuriesLimited investigationFinal reportMasnic SKY Hopper II · Edgewood, NMthe pilot exceeding the airplane's crosswind component which led to his inability to compensate for the crosswind conditions. A factor was the gusty winds.NTSB SEA96TA050Accident · No injuriesFinal reportBell 206B · Kemmerer, WYthe selection of an unsuitable landing zone by the pilot.NTSB NYC96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mattituck, NYthe student pilot's inadequate inflight decision and inadequate evaluation of the weather which resulted in a downwind landing and runway overrun. The student pilot's failure to follow directives was a contributing factor.NTSB NYC96LA058Accident · Minor injuriesLimited investigationFinal reportBeech 1900D · Bradford, PAthe pilot misjudged the flare during landing. Factors in the accident were: an improper recovery from a bounced landing, and the first officers lack of experience in this type operation.NTSB DCA96RA030Accident · 189 fatalForeign investigationBoeing 757-200 · Puerto Plata, Dominican RepublicNTSB ATL96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32-RT-300 · Blountville, TNInadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.NTSB SEA96LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Heber City, UTthe pilot's attempted VFR flight into IMC, and his failure to maintain adequate altitude and clearance from terrain during the landing flare. Factors contributing to the accident were the snowbank, fog, and the pilot's complacent attitude.NTSB LAX96RA116Accident · 8 fatalForeign investigationCessna 550 · Ensenada, MexicoNTSB LAX96LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Barstow, CAfailure of the pilot to maintain adequate terrain clearance, while maneuvering around a ground vehicle at low altitude.NTSB LAX96LA107Accident · No injuriesLimited investigationFinal reportCessna 177 · Corona, CAimproper planning/decision by the pilot-in-command (PIC), and his failure to ensure that adequate airspeed was obtain and/or maintain during lift-off/initial climb. A factor relating to the accident was: the PIC allowed the airplane's maximum gross weight…NTSB NYC96LA059Accident · No injuriesLimited investigationFinal reportCessna 180D · Islesboro, MEa loss of engine power for an undetermined reason.NTSB LAX96FA106Accident · 4 fatalField investigationFinal reportConvair C-131E · Saint Johns, AZinadequate preflight planning and preparation by the first pilot (PIC), his failure to ensure the aircraft was properly loaded within limitations, his failure to use proper flaps for takeoff, his failure to use ADI assisted takeoff, and his resultant failure…NTSB SEA96LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Mcleary, WAfailure of the pilot to maintain sufficient altitude/clearance from mountainous/wooded terrain. Factors relating to the accident were: the terrain and downdraft conditions.NTSB FTW96LA111Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas MD-88 · Denver, COFailure of the pilot to maintain sufficient airspeed to properly flare the airplane during the landing.NTSB FTW96LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cushing, OKThe inadvertent deployment of the passenger's parachute as a result of his failure to follow proper procedures and deactivate the automatic opening device on the parachute.NTSB SEA96TA046Accident · Minor injuriesFinal reportChristen Industries A-1 · Lakeview, ORfailure of the pilot to maintain altitude/clearance from the terrain (snow covered, frozen lake). Factors relating to the accident were: the pilot's attention being diverted to a perceived safety hazard, and lack of visual cues for pilot perception of…NTSB MIA96LA074Accident · 1 fatalLimited investigationFinal reportYakovlev YAK-52 · Boynton Beach, FLPilot impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude above the terrain while performing an aerobatic maneuver. Factors relating to the accident were: the pilot's…NTSB ATL96LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-45G · Blountville, TNthe pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…NTSB LAX96LA104Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kamuela, HIfailure of the nose case (No.1) bearing resulting in oil starvation.NTSB FTW96FA145Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Estes Park, CODescent into mountainous terrain for reasons undetermined.NTSB ATL96FA043Accident · No injuriesField investigationFinal reportDouglas DC-9-32 · Nashville, TNthe failure of the right main landing gear shock strut cylinder due to preexisting fractures. Contributing to the accident was: the failure of the operator to inspect the shock strut cylinder for fractures following a previous failure of the torque links, and…NTSB LAX96FA105Accident · 3 fatalField investigationFinal reportBeech E90 · Flagstaff, AZfailure of the pilot to follow prescribed IFR procedures and his failure to maintain control of the aircraft. Factors relating to the accident were: the adverse weather conditions with icing and turbulence.NTSB CHI96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Marion, INthe pilot's failure to maintain directional control during landing.NTSB LAX96LA111Accident · 1 fatalLimited investigationFinal reportBell 47G-2A1 · Honiara, Solomon Islandsthe pilot and the ship crew's failure to assure the tie down strap was removed prior to liftoff.NTSB LAX96FA103Accident · 1 fatalField investigationFinal reportCessna 402B · Kamuela, HIfailure of the copilot (pilot-rated cargo loader, who was flying the aircraft) to establish and maintain a positive rate of climb after taking off at night; and inadequate supervision by the pilot-in-command (PIC), by failing to ensure that proper altitude…NTSB LAX96LA102Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hilo, HIInadequate supervision of the student pilot by the flight instructor during an attempted go-around from a balked landing, which resulted in a loss of directional control and collision with a distance remaining marker.