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 IAD99FA034Accident · 2 fatalField investigationFinal reportBeech BE-76 · Dravosburg, PAThe pilot's failure to accurately calculate fuel required for the flight, and his decision not to divert for fuel prior to his intended destination. A factor in the accident was the pilot's over confidence in his ability to operate the airplane with minimal…Mar 15, 1999 · N6638C · DestroyedNTSB FTW99LA111Accident · No injuriesLimited investigationFinal reportCessna 182Q · Galveston, TXThe pilot's delayed landing flare of the aircraft. Factors were the excessive airspeed and the pilot's lack of experience in the make and model of aircraft.Mar 15, 1999 · N7608S · Substantial damageNTSB DCA99WA048Accident · No injuriesForeign investigationMcDonnell Douglas MD-83 · Pohang, South KoreaMar 15, 1999 · HL757 · Substantial damageNTSB CHI99LA109Accident · No injuriesLimited investigationFinal reportPiper J5A · Wausau, WIthe loss of engine power for undetermined reasons and the lack of suitable terrain for landing. A factor to the accident was the aircraft owner not performing necessary maintenance to the aircraft.Mar 15, 1999 · N40888 · Substantial damageNTSB NYC99LA072Accident · Minor injuriesLimited investigationFinal reportMiner Rotorway Exec 162F · Mechanicsburg, PAThe pilot's inadvertent induced dynamic rollover. A factor in the accident was the pilot's lack of helicopter experience.Mar 14, 1999 · N124CF · Substantial damageNTSB LAX99LA119Accident · Minor injuriesLimited investigationFinal reportGallob Rans S4 · Mesa, AZThe pilot's failure to adequately compensate for the existing crosswind condition and to maintain lateral control of the aircraft.Mar 14, 1999 · N199AG · Substantial damageNTSB DEN99LA055Accident · No injuriesLimited investigationFinal reportCessna 310L · Angel Fire, NMThe pilot's exceeding the airplane's weight and balance limitations. A factor was the high density altitude weather condition.Mar 14, 1999 · N2230F · Substantial damageNTSB DEN99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Leadville, COThe pilot's inadequate compensation for the gusty crosswind conditions. A factor was the gusting crosswindMar 14, 1999 · N90995 · Substantial damageNTSB DEN99FA051Accident · 2 fatalField investigationFinal reportCessna 172 · Gill, COThe pilot's intentional maneuvering at an unwarranted low altitude resulting in a collision with the ground. Factors were the pilot's ostentatious behavioral display and reduced lighting (dusk) conditions.Mar 14, 1999 · N6085A · DestroyedNTSB CHI99LA107Accident · No injuriesLimited investigationFinal reportPiper J4A · Howell, MIthe pilot's failure to maintain clearance with the snow covered terrain off the side of the runway while turning the airplane around on the runway. A factor associated with the accident was the snow covered terrain.Mar 14, 1999 · N30412 · Substantial damageNTSB ATL99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Laurens, SCThe pilot's disregard for current wind conditions and his failure to maintain directional control during landing. Factors were the tailwind and wet runway surface.Mar 14, 1999 · N345RP · Substantial damageNTSB ANC99LA033Accident · No injuriesLimited investigationFinal reportCessna 180G · Fairbanks, AKWater contamination of the fuel supply, and the pilot's inadequate preflight inspection to ensure all water was removed from the fuel supply. Factors in the accident were a wrinkle in the wing fuel tank bladder, and snow covered terrain.Mar 14, 1999 · N4721U · Substantial damageNTSB SEA99LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rexburg, IDA loss of engine power for undetermined reasons.Mar 13, 1999 · N9578W · Substantial damageNTSB NYC99LA075Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Winchester, VAThe pilot's failure to extend the landing gear before landing on the runway.Mar 13, 1999 · N700SP · Substantial damageNTSB LAX99LA118Accident · No injuriesLimited investigationFinal reportCessna 305A · Coalinga, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the airplane.Mar 13, 1999 · N5188G · Substantial damageNTSB LAX99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Rubidoux, CAThe pilot's failure to maintain adequate clearance from parked airplanes while taxiing due to his diverted attention.Mar 13, 1999 · N5346W · Substantial damageNTSB DEN99LA056Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Evanston, WYA total loss of engine power for undetermined reasons.Mar 13, 1999 · N49J · Substantial damageNTSB DEN99IA053Incident · No injuriesIncident investigationFinal reportGulfstream G-IV · Durango, COThe failure of the number four fuel line. Factors were the chaffing of the alternator's electrical wires on the number four fuel line, and the subsequent fire in the number one engine nacelle.Mar 13, 1999 · N411WW · Minor damageNTSB ANC99LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's inadequate preflight inspection, and his failure to refuel the airplane that resulted in fuel exhaustion.Mar 13, 1999 · N4387B · Substantial damageNTSB NYC99FA071Accident · 1 fatalField investigationFinal reportMooney M20K · Counts, VAThe pilot's failure to maintain control of the airplane.Mar 12, 1999 · N231HU · DestroyedNTSB ATL99LA054Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Knoxville, TNA loss of engine power for undetermined reasons. Contributing to the accident was the failure of the landing gear to extend for undetermined reasons.Mar 12, 1999 · N176BJ · Substantial damageNTSB ATL99LA051Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Finley, TNThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the gusting winds.Mar 12, 1999 · N36484 · Substantial damageNTSB SEA99LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Hailey, IDThe pilot's failure to maintain aircraft control after touchdown. Factors contributing to the accident were a snow bank along the runway edge and a crosswind.Mar 11, 1999 · N1622E · Substantial damageNTSB MIA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mt. Vernon, GAThe pilot's improper flare that resulted in a hard landing in an open field. A factor was the high output flow of the fuel injector servo that resulted in a loss of engine power and the forced landing.Mar 11, 1999 · N3218W · Substantial damageNTSB DCA99WA049Incident · No injuriesForeign investigationBoeing 727-200 · Calgary, CanadaMar 11, 1999 · N8873Z · Minor damageNTSB CHI99FA105Accident · 1 fatalField investigationFinal reportBeech C-45G · Romulus, MIthe aircraft control not maintained and the inadvertent stall by the pilot while maneuvering to the landing area. The open door was a contributing factor.Mar 11, 1999 · N234L · DestroyedNTSB LAX99TA115Accident · Minor injuriesFinal reportMcDonnell Douglas 600N · Rialto, CAThe pilot's improper in-flight decision to maneuver in the area while observed inclement weather approached, which led to a loss of control. Contributing factors were the low ceilings, mountainous terrain and spatial disorientation.Mar 10, 1999 · N626SB · Substantial damageNTSB LAX99LA116Accident · Minor injuriesLimited investigationFinal reportBell 206B · Delhi, CAThe pilot's failure to maintain clearance while landing in proximity to high vegetation, which resulted in the inadvertent contact of the spray boom to the trees.Mar 10, 1999 · N901CA · Substantial damageNTSB FTW99LA092Accident · No injuriesLimited investigationFinal reportSchweizer Hughes 269C · Laredo, TXThe loss of engine power due to a bearing shift, which resulted in fatigue cracking of the crankshaft and subsequent failure of the crankshaft. A factor was a lack of suitable terrain for the forced landing.Mar 10, 1999 · N36254 · Substantial damageNTSB CHI99LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · South St. Paul, MNthe student pilot's failure to maintain directional control of the airplane during takeoff. Factors associated with the accident were the student's lack of experience and the snowbank.Mar 10, 1999 · N89084 · Substantial damageNTSB CHI99LA103Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIThe pilot's improper flare and failure to maintain directional control. Related factors were the snowbank and lack of total experience.Mar 10, 1999 · N983AV · Substantial damageNTSB CHI99LA091Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe loss of directional control by the pilot. Factors to the accident were the lack of total experience of the pilot, the snow covered runway condition, the snowbank, and the flight instructor not verifying the runway snow removal with the Duty Instructor…Mar 10, 1999 · N989AV · Substantial damageNTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.Mar 9, 1999 · N41096 · Substantial damageNTSB NYC99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Richmond, VAThe pilot's inadequate preflight planning/preparation which resulted in flight into icing weather conditions. A factor related to the accident was restricted visibility through the icy windshield during landing.Mar 9, 1999 · N5454F · Substantial damageNTSB DEN99LA050Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Santa Rosa, NMThe unfavorable wind gust which inverted the airplane while taxiing.Mar 8, 1999 · N8470K · Substantial damageNTSB CHI99LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Grand Ledge, MIthe flight instructor's failure to successfully take remedial action to maintain directional control of the airplane during the landing roll out. Factors were the crosswinds and snowbank.Mar 8, 1999 · N432W · Substantial damageNTSB LAX99LA114Accident · No injuriesLimited investigationFinal reportCessna 180F · Inyokern, CAthe pilot's inadequate compensation for the variable and gusting winds during a wheel landing, which led to a loss of directional control.Mar 7, 1999 · N345RC · Substantial damageNTSB CHI99LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILthe pilot's inadequate directional control during landing roll. A factor was the snow bank.Mar 7, 1999 · N65192 · Substantial damageNTSB ANC99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing the wheel equipped airplane. A factor associated with the accident was the soft snow covering the frozen lake.Mar 7, 1999 · N4040M · Substantial damageNTSB SEA99LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Salem, ORThe pilot-in-command's misjudgment of distance/altitude on final approach, and overload of the left main landing gear. A factor was the embankment at the end of the landing strip.Mar 6, 1999 · N4328X · Substantial damageNTSB MIA99LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Lantana, FLthe pilot misjudged the flare, resulting in a hard landing, and subsequent impact with the runway.Mar 6, 1999 · N2890X · Substantial damageNTSB MIA99LA100Accident · No injuriesLimited investigationFinal reportMooney 20G · Naples, FLthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a off airport forced landing. Contributing factors in this accident were the pilot's inadequate pre-flight and in-flight…Mar 6, 1999 · N3588X · Substantial damageNTSB FTW99LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange, TXThe student pilot's failure to maintain directional control during landing touchdown. A factor was the muddy drainage ditch.Mar 6, 1999 · N5803E · Substantial damageNTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…Mar 6, 1999 · N4312A · 2 aircraft · DestroyedNTSB MIA99WA104Accident · No injuriesForeign investigationFokker F-27F · Quito, EcuadorMar 5, 1999 · HCBSL · Substantial damageNTSB DEN99LA047Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Denver, COThe pilot of N328BA's failure to maintain visual lookout while taxiing, causing the subsequent collision with N151SA.Mar 5, 1999 · N151SA · 2 aircraft · Substantial damageNTSB DCA99WA047Accident · No injuriesForeign investigationBoeing 747-200F · Madras, IndiaMar 5, 1999 · UNK · DestroyedNTSB CHI99FA102Accident · No injuriesField investigationFinal reportDouglas DC-9-15F · Kansas City, MOingestion of birds into both engines, resulting in foreign object damage and the subsequent partial power loss to both engines. A factor relating to this accident was the dark night.Mar 5, 1999 · N195US · Substantial damageNTSB FTW99LA091Accident · No injuriesLimited investigationFinal reportCessna 172D · Homer, LAThe loss of engine power due to fuel starvation, as a result of fuel moving away from the fuel supply outlets. Factors were the low fuel level and the turbulence.Mar 4, 1999 · N2645U · Substantial damageNTSB FTW99LA089Accident · No injuriesLimited investigationFinal reportCessna 182C · Conway, ARThe total loss of engine power due to carburetor ice. Factors were the weather condition conducive to the formation of carburetor ice and the lack of suitable terrain for the forced landing.Mar 4, 1999 · N8645T · Substantial damage