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 ANC99LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe loss of engine power due to the failure of maintenance personnel to properly torque a connecting rod bolt during an engine overhaul, and the subsequent disconnection of the connecting rod bolt and connecting rod.NTSB LAX99LA139Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Ramona, CAThe pilot's failure to maintain an adequate airspeed margin to compensate for the variable wind conditions existing at the time of the landing.NTSB LAX99FA138Accident · 4 fatalField investigationFinal reportPiper PA-32R-301 · Warner Springs, CAThe pilot disregarded his weather briefing and attempted flight into areas of forecast and reported icing and moderate to severe turbulence. The airplane encountered mountain wave activity resulting in an overload condition and in-flight separation of the…NTSB LAX99FA137Accident · 3 fatalField investigationFinal reportMbb B0-105CBS-4 · Indian Springs, NVthe pilot's decision to continue VFR flight in deteriorating IFR conditions resulting in spatial disorientation and subsequent loss of control.NTSB FTW99FA104Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Waldron, ARThe pilot's encounter with adverse weather and loss of aircraft control, which resulted in exceeding the aircraft's design stress limits. Factors were the pilot's lack of total experience in the make and model of airplane, and the icing and thunderstorm…NTSB ANC99LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe improper installation of the main landing gear attaching bolt by maintenance personnel, which resulted in total failure of the bolt and collapse of the landing gear.NTSB ANC99LA041Accident · No injuriesLimited investigationFinal reportMaule M-5 · Talkeetna, AKThe pilot's inadequate compensation for the crosswind during landing. Factors associated with this accident were the left crosswind, and the snowbank on the edge of the runway.NTSB NYC99LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Ramapo, NYFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor in the accident was the flight instructor's inadequate supervision of the solo cross-country flight.NTSB NYC99LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln Univ., PAThe student pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush. Also causal was the certified flight instructor's inadequate supervision.NTSB NYC99FA085Accident · 2 fatalField investigationFinal reportCessna 310N · Cecilia, KYThe flight instructor's failure to maintain control of the airplane. A factor was the flight instructor's inexperience instructing in the accident airplane.NTSB MIA99LA116Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235B · Boca Grande, FLThe pilots failure to maintain a visual lookout on landing resulting in an in-flight collision with a wave.NTSB LAX99WA141Accident · 7 fatalForeign investigationBell 412 · Santan, IndonesiaNTSB SEA99LA046Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Edison, WAA total loss of engine power due to fatigue of the number six crankcheek resulting in crankshaft separation, and the lack of suitable terrain. Contributing factors were the sign and the ditch.NTSB NYC99LA086Accident · No injuriesLimited investigationFinal reportCessna 172P · Lawrence, MAThe student pilot's improper flare, and his improper recover from a bounced landing.NTSB MIA99LA117Accident · Serious injuriesLimited investigationFinal reportWaco YMF-5 · Boca Raton, FLThe pilot's failure to select a suitable forced landing site following a partial loss of engine power due to failed cylinder holdddown studs, and the subsequent collision with trees. A factor in the accident was the reduced forward visibility from the dual…NTSB DEN99LA062Accident · No injuriesLimited investigationFinal reportSly RV-6A · Payson, UTThe development of carburetor ice resulting in a loss of engine power, and the inadequate carburetor heat shroud. Factors were the carburetor icing weather conditions, the kit manufacturer's inadequate carburetor heat shroud design, the FAA's inadequate…NTSB SEA99IA045Incident · No injuriesIncident investigationFinal reportFokker F.28 MK 4000 · Spokane, WAA chafed hydraulic line.NTSB LAX99FA136Accident · 1 fatalField investigationFinal reportBell 206B · Grand Canyon, AZThe failure of the flight crew to properly preflight the helicopter and to detect and remove accumulated snow from the engine inlets and plenum chamber. Factors in the accident were the clouded plenum chamber inspection window and the failure of preceding…NTSB CHI99FA227Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · St. Clair Shore, MIUndetermined as the aircraft was not recovered.NTSB ATL99FA066Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Tallahassee, FLThe pilot's failure to maintain flying speed during initial climb which resulted in a stall and uncontrolled collision with terrain.NTSB ANC99LA040Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Fairbanks, AKThe failure of the pilot to maintain rotor rpm during a downwind turn. A factor in the accident was the inadequate altitude to recover from the loss of rotor rpm.NTSB NYC99LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Leonardtown, MDThe pilot's failure to maintain control of the airplane during a crosswind landing.NTSB NYC99LA083Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Orient, NYThe pilot's inadequate compensation for crosswind conditions during takeoff.NTSB LAX99LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Novato, CAThe failure of the pilot to adequately compensate for the wind conditions and to maintain directional control of the aircraft while landing. A factor is the airport's failure to follow proper procedure in ensuring adequate obstacle and object free clearance…NTSB LAX99LA132Accident · No injuriesLimited investigationFinal reportCessna 172B · Winslow, AZThe pilot's decision to continue flight into known adverse wind conditions which exceeded the ground handling capability of the aircraft.NTSB FTW99LA107Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXThe pilot's inability to maintain directional control of the airplane as result of the failure of the right brake system due to the stripped threads on the eye bolt connecting the brake pedal to the brake master cylinder.NTSB FTW99LA103Accident · Minor injuriesLimited investigationFinal reportGates Learjet 35A · Rogers, ARThe pilot's failure to maintain the proper descent rate, his failure to attain the proper touchdown point and the fightcrew's delay in taking remedial action. A factor was the downdraft.NTSB ATL99LA064Accident · No injuriesLimited investigationFinal reportCessna 172B · Mt. Airy, NCThe pilot's failure to maintain proper airspeed during landing and his failure to attain a proper touchdown point on the runway.NTSB ATL99LA063Accident · No injuriesLimited investigationFinal reportCessna 185 · Hilton Head, SCThe pilot's inadequate evaluation of weather information that resulted in his failure to maintain directional control during landing. Factors were gusting winds, and a tail wind.NTSB ATL99LA062Accident · No injuriesLimited investigationFinal reportCessna 210 · Opa Locka, FLThe loss of engine power for undetermined reasons.NTSB NYC99LA082Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Westerville, OHThe failure of the pilot to maintain control of the helicopter.NTSB LAX99LA134Accident · No injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAThe failure and separation of the number two cylinder for undetermined reasons. A factor was the soft terrain at the forced landing site.NTSB FTW99LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ada, OKThe pilot's excessive application of the wheel brakes.NTSB ATL99LA061Accident · No injuriesLimited investigationFinal reportCessna 150J · Pembroke Pines, FLThe pilot's inadequate in-flight/planning decision and his mismanagement of the fuel supply.NTSB NYC99LA081Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pottstown, PAThe failure of maintenance personnel to properly inspect and torque the crankcase bolts.NTSB MIA99LA115Accident · No injuriesLimited investigationFinal reportBeech A23 · Homestead, FLThe pilots improper decision not to land straight ahead after sustaining a reported loss of engine power on initial take off climb with sufficient runway remaining, and improper recovery from a bounced landing resulting in a subsequent in-flight collision…NTSB DEN99LA061Accident · No injuriesLimited investigationFinal reportMooney M20K · Medicine Bow, WYA fluctuating turbine inlet temperature and resulting loss of engine power for undetermined reasons. Factors were the rough, unsuitable terrain on which to make a forced landing.NTSB DEN99LA059Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Elbert, COThe pilot's failure to maintain a proper descent rate during touchdown, resulting in a hard landing. A factor was the passenger's failure to properly position herself for the landing.NTSB CHI99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ankeny, IAThe student pilot's failure to maintain directional control during landing.NTSB ATL99LA065Accident · No injuriesLimited investigationFinal reportCessna 206 · Fayetteville, NCThe pilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB ANC99LA038Accident · No injuriesLimited investigationFinal reportCessna 170B · Mccarthy, AKThe pilot's failure to abort the takeoff in a timely manner. Factors associated with the accident were a tailwind, the pilot's inadequate weather evaluation, and the pilot's premature liftoff.NTSB ANC99LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the soft, snow-covered terrain.NTSB LAX99LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Scottsdale, AZFailure of the student pilot to maintain directional control of the aircraft while retracting the flaps during a touch-and-go.NTSB DEN99LA060Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Coyote, NMThe pilot-in-command's inadvertent flight into adverse weather, and his continued flight into instrument meteorological conditions. Factors were his failure to obtain an updated recorded weather briefing, the existing weather conditions which included snow,…NTSB DEN99FA064Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Pagosa Springs, COThe pilot's continued VFR flight into IMC conditions. Related factors were flight into known adverse weather, the adverse weather, mountain obscuration, snow, icing, and high density altitude.NTSB CHI99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marquette, MIthe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain directional control. Factors associated with the accident were the gusty crosswind conditions and the taxiway sign which the airplane contacted.NTSB ATL99LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Dahlonega, GAThe pilot's failure to maintain directional control during takeoff.NTSB ANC99LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Chefornak, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was rough and uneven terrain.NTSB SEA99LA044Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Port Angeles, WAThe pilot's improper in-flight decision which resulted in a loss of power due to a contaminated fuel system. Factors include unsuitable terrain and the fence.NTSB FTW99LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jennings, LAThe pilot's inadvertent stall during the departure turn to downwind. A factor was the tailwind.