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.

NTSB ANC99LA107Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Ketchikan, AKA failure of ground handling personnel to verify a release procedure/directive, and removal of the airplane's tiedown, and subsequent collision with a parked airplane.Aug 7, 1999 · N288SA · 2 aircraft · Substantial damageNTSB ANC99FA110Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Anaktuvuk Pass, AKThe inadvertent stall/spin by the pilot. A factor was the box canyon into which he had flown.Aug 7, 1999 · N4996V · DestroyedNTSB NYC99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Dorrance, PAThe pilot's misjudgment of distance and altitude, and his failure to do a go-around.Aug 6, 1999 · N4352P · Substantial damageNTSB MIA99FA215Accident · 2 fatalField investigationFinal reportCessna 150F · Maple, NCthe pilot's failure to follow the aircraft's operating checklist and retract the wing flaps for takeoff as specified, as well as the pilot's failure to maintain airspeed (Vso) on initial takeoff climb, which resulted in an inadvertent stall, a spin, and…Aug 6, 1999 · N7059F · DestroyedNTSB LAX99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Coalinga, CAThe flight instructor's failure to maintain a sufficient airspeed to compensate for the known wind shear condition, which resulted in a failure to maintain runway alignment and a hard landing. The flight instructor's inadequate supervision of the flight was…Aug 6, 1999 · N6814W · Substantial damageNTSB DEN99LA139Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Elizabeth, COA forced landing on unsuitable terrain following a total loss of power for non mechanical reasons. Factors were the pilot's failure to follow emergency procedures for restarting the engine, operating the aircraft with known deficiencies, and inaccurate…Aug 6, 1999 · N3059W · Substantial damageNTSB DEN99FA137Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMThe pilot's failure to maintain sufficient airspeed during final approach to landing, resulting in an inadvertent stall. A factor was the high density altitude.Aug 6, 1999 · N6687B · DestroyedNTSB CHI99LA283Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's misjudged landing flare and his inadequate recovery from the bounced landing.Aug 6, 1999 · N933LA · Substantial damageNTSB CHI99LA277Accident · No injuriesLimited investigationFinal reportCessna 150M · Sikeston, MOthe loss of engine power due to the stuck exhaust valve. A factor was the lack of suitable terrain available for the forced landing.Aug 6, 1999 · N3755V · Substantial damageNTSB CHI99FA278Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Grayslake, ILthe pilot not maintaining altitude and clearance. Factors were the light condition of night, the pilot's lack of recent experience in night operations, and the transmission wire.Aug 6, 1999 · N56718 · DestroyedNTSB NYC99LA190Accident · Minor injuriesLimited investigationFinal reportRobinson R-22A · Shirley, NYThe pilot's failure to maintain rotor RPM, which resulted in a hard landing.Aug 5, 1999 · N8561K · Substantial damageNTSB LAX99LA263Accident · Serious injuriesLimited investigationFinal reportPartenavia P68C · Kaunakakai, HIThe prospective passenger's intentional act of bypassing proscribed airport procedures for boarding aircraft. A factor was the failure of another operator's ground personnel to comply with ramp access restrictions.Aug 5, 1999 · N4234L · Minor damageNTSB FTW99LA210Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Whitewright, TXThe pilot's failure to maintain directional control of the airplane.Aug 5, 1999 · N141CH · Substantial damageNTSB DEN99IA136Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COSee cause/factor narrative for DEN 99-I-A136A.Aug 5, 1999 · N101UX · 2 aircraft · Minor damageNTSB CHI99FA276Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Lake Geneva, WIthe aborted takeoff not performed by the safety-pilot and airspeed not obtained/maintained by the safety-pilot. Factors to the accident were directional control and runway alignment not maintained by the pilot-in-command, the inadequate supervision of the…Aug 5, 1999 · N4337X · Substantial damageNTSB ANC99FA106Accident · 2 fatalField investigationFinal reportCessna 180A · Kenai, AKThe pilot's intentional visual flight into known adverse weather. Factors associated with this accident were the reported low ceilings, obscuration, high winds, and turbulence.Aug 5, 1999 · N8TL · DestroyedNTSB DEN99LA135Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe unforecasted sudden wind change, and the pilot's failure to maintain aircraft control. A factor was the down sloping terrain next to the runway.Aug 4, 1999 · N733CK · Substantial damageNTSB DEN99LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · Casper, WYThe pilot's selection of a wrong runway for landing and his failure to maintain directional control.Aug 4, 1999 · N4448B · Substantial damageNTSB DEN00LA109Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Wheatland, WYThe flight instructor's failure to maintain control of the aircraft. Factors were inadequate supervision of the student by the flight instructor and inaccurate judgment by the flight instructor in not having the aircraft examined following the event.Aug 4, 1999 · N4789J · Substantial damageNTSB MIA99LA213Accident · No injuriesLimited investigationFinal reportWilliam Jay Kinney Challenger II · Pahokee, FLfailure of the engine to propeller drive belt for undetermined reasons, resulting in loss of engine power, and a forced landing to unsuitable terrain.Aug 3, 1999 · N14131 · Substantial damageNTSB LAX99FA262Accident · 2 fatalField investigationFinal reportCessna 177B · Tusayan, AZwas the pilot's failure to have available and consult the FAA approved flight manual for performance data and, the high density altitude. Contributing to the accident were the dual magneto and spark plug system issues affecting optimum engine performance.Aug 3, 1999 · N19113 · DestroyedNTSB IAD99GA056Accident · Minor injuriesFinal reportEurocopter AS-350 · Islip, NYThe pilot's loss of control during hydraulics-off hovering flight and the instructor's inadequate supervision of the maneuver. A factor was the tailwind.Aug 3, 1999 · N211PD · Substantial damageNTSB FTW99WA209Accident · 5 fatalForeign investigationPiper PA-32-260 · Guayaquil, EcuadorAug 3, 1999 · HCAKO · DestroyedNTSB DEN99FA142Accident · 1 fatalField investigationFinal reportCessna 172P · Grants, NMThe pilot's failure to fly the aircraft at an altitude sufficient to clear surrounding terrain. Factors were: The pilot's in-flight planning and decision making in proceeding into known adverse weather. Low ceiling, rain, lack of total pilot experience, and…Aug 3, 1999 · N6497K · DestroyedNTSB ANC99LA115Accident · No injuriesLimited investigationFinal reportCessna 180 · Sand Point, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was a large rock.Aug 3, 1999 · N49JT · Substantial damageNTSB ANC99LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Kenai, AKThe loss of control due to wake turbulence, and the issuance of an improper takeoff clearance by air traffic control personnel. A factor associated with the accident was air traffic control personnel's failure to issue a safety advisory.Aug 3, 1999 · N95031 · Substantial damageNTSB NYC99LA192Accident · No injuriesLimited investigationFinal reportBeech A36 · Westminster, MDThe pilot-in-command's failure to maintain aircraft control while landing.Aug 2, 1999 · N6357Y · Substantial damageNTSB MIA99LA212Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Moore Haven, FLThe pilot exceeding the gross takeoff weight which reduced the climb capability and subsequent in-flight collision with terrain. Contributing to the accident was the high temperature and the pilot's failure to use aircraft performance data for the weather…Aug 2, 1999 · N15585 · Substantial damageNTSB LAX99FA261Accident · 1 fatalField investigationFinal reportPorterfield CP-65 · Johnson Valley, CAThe failure of the pilot to maintain adequate airspeed while attempting to make a precautionary landing, which resulted in a stall/spin and collision with the terrain. A factor in his failure to maintain an adequate airspeed is the pilot's likely diverted…Aug 2, 1999 · N32409 · DestroyedNTSB FTW99LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Bryan, TXThe flight instructor's inadvertent stall while performing an evasive maneuver to avoid colliding with powerlines.Aug 2, 1999 · N444UF · Substantial damageNTSB CHI99LA272Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · North Platte, NEThe pilot's improper inflight planning decision which resulted in fuel exhaustion. A factor associated with the accident was the dark night conditions.Aug 2, 1999 · N8509R · Substantial damageNTSB SEA99LA133Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Renton, WAA loss of engine power for undetermined reasons. A factor was insufficient altitude available to return to the departure runway following the loss of power.Aug 1, 1999 · N3151G · Substantial damageNTSB NYC99LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Frederick, MDThe pilot's failure to maintain directional control. Contributing factors were gusty wind conditions and the sign.Aug 1, 1999 · N70894 · Substantial damageNTSB NYC99LA188Accident · No injuriesLimited investigationFinal reportCessna 172R · Cheswold, DEThe pilot's improper flare and improper recovery from a bounced landing.Aug 1, 1999 · N2746C · Substantial damageNTSB NYC99FA187Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · North Lima, OHThe pilot's loss of control of the airplane during a turn. Factors include the pilot's failure maintain sufficient airspeed, and his failure to maintain the airplane in proper trim.Aug 1, 1999 · N5526J · DestroyedNTSB MIA99LA211Accident · No injuriesLimited investigationFinal reportMooney M-20R · Stoneville, NCthe pilot's failure to maintain airspeed, and adequately compensate for torque and P-factor, resulting in the loss of directional control, collision with hangars, and substantial damage to the aircraft during the attempted go around/recovery from a landing.Aug 1, 1999 · N9169E · Substantial damageNTSB MIA99LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Greenville, SCA total loss of engine power while in descent for landing due to fuel exhaustion as a result of the pilot's failure to properly plan and load the fuel required, and the subsequent collision with the terrain during a forced landing.Aug 1, 1999 · N3206V · Substantial damageNTSB MIA99FA208Accident · 1 fatalField investigationFinal reportGulfstream American AA-1B · Hilliard, FLthe pilot's failure to obtain notams and his improper planning and decision to use a closed runway for takeoff with tall trees on the departure end, resulting in a subsequent collision with the trees.Aug 1, 1999 · N9888L · DestroyedNTSB CHI99LA274Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Harlan, IAthe failure of the pilot to maintain directional control of the aircraft during landing. Factors to the accident were the crosswind, the failure of the pilot to maintain compensation for the crosswind condition on approach, and the inadvertent ground loop…Aug 1, 1999 · N98FP · Substantial damageNTSB ANC99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Levelock, AKThe pilot's selection of an unsuitable landing site.Aug 1, 1999 · N693JB · Substantial damageNTSB ANC99LA102Accident · No injuriesLimited investigationFinal reportCessna 180A · Gustavus, AKThe pilot's inadvertent ground loop/swerve.Aug 1, 1999 · N6180 · Substantial damageNTSB ANC99LA101Accident · No injuriesLimited investigationFinal reportHaering Avid Flyer Avid Flyer · Anchorage, AKA loss of engine power due to blockage of the airplane fuel system, a delamination of the fiberglass fuel tanks, and the usage of an improper fuel. A factor associated with the accident was the failure of the kit manufacturer to inform the pilot/owner against…Aug 1, 1999 · N511AF · Substantial damageNTSB SEA99LA140Accident · No injuriesLimited investigationFinal reportCessna T210J · Sequim, WAThe pilot's failure to adequately compensate for the changing wind conditions. Factors include a berm located off the east end of the runway and a tailwind.Jul 31, 1999 · N821SB · Substantial damageNTSB SEA99LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's improper remedial action (continued takeoff). Contributing factors were the tree and control interference (inadvertent brake activation) by the passenger..Jul 31, 1999 · N6741L · Substantial damageNTSB NYC99LA189Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Greencastle, PAThe pilot's misjudgement of speed and distance during the approach and his failure to perform a go around.Jul 31, 1999 · N5801P · Substantial damageNTSB NYC99LA186Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Pittstown, NJThe pilot's failure to obtain the proper touchdown point.Jul 31, 1999 · N6PS · Substantial damageNTSB MIA99LA210Accident · No injuriesLimited investigationFinal reportWilderoder Great Lakes 2TIA · Pensacola, FLThe pilot's failure to check the brake hydraulic fluid reservoir prior to flight resulting in a low fluid level going undetected and failure of the brakes during landing rollout, which resulted in the aircraft overrunning the runway, colliding with a fence,…Jul 31, 1999 · N47149 · Substantial damageNTSB DEN99LA133Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Montrose, COThe pilot's inadequate preflight planning and preparation and his failure to maintain clearance from the signpost. A factor was the signpost.Jul 31, 1999 · N9390V · Substantial damageNTSB DEN99LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Edgewood, NMThe pilot's excessive rotation during takeoff, resulting in an inadvertent stall/mush. Factors were the pilot's lack of recent flight experience, and the high density altitude..Jul 31, 1999 · N7521W · Substantial damageNTSB CHI99MA269Accident · 10 fatalMajor investigationFinal reportBeech 65-A90 · Marine City, MIThe pilot's failure to maintain adequate airspeed, which resulted in a stall, inflight loss of contol, and collision with the ground.Jul 31, 1999 · N518DM · Destroyed