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 ANC88LA070Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Black Lake, AKThe pilot attempted a landing at a mining strip which was 1000 feet long. The pilot overshot the runway touchdown point; he then attempted a go-around, lost control , and crashed 300 feet off the departure end of the runway.Jun 22, 1988 · N2183F · Substantial damageNTSB MKC88LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Eldon, MOTotal failure of the powerplant due to an oil line rupture, and proper touchdown point not attained by the pilot in command.Jun 21, 1988 · N4490T · Substantial damageNTSB LAX88DVA07Accident · 1 fatalFinal reportAyres S2R · Firebaugh, CADuring an agricultural spraying run, the airplane was required to fly under power lines to complete the job. The airplane was seen flying in the direction of the wires. The airplane initially contacted a levee with the wing and then collided with a power…Jun 21, 1988 · N5512X · DestroyedNTSB FTW88LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Clifton, TXThe student pilot was on her third landing during her first solo flight. The pilot reported that she lost control and the airplane ground looped during the landing roll.Jun 21, 1988 · N76505 · Substantial damageNTSB DEN88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDJun 21, 1988 · N96730 · Substantial damageNTSB ATL88LA197Accident · Serious injuriesLimited investigationFinal reportAeronca 0-58B · Newberry, SCThe pilot related that he had been flying around the local area making landings at various airports for about 1 1/2 hours. He returned to the departure airport and made a full stop landing. His 12 year old son requested that he make another takeoff and…Jun 21, 1988 · N47190 · DestroyedNTSB ANC88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot stated that after touchdown on the runway a gust of wind hit the plane pushing the tail to the right and causing the aircraft to ground loop.Jun 21, 1988 · N4260H · Substantial damageNTSB SEA88LA115Accident · Minor injuriesLimited investigationFinal reportPeterson J-4 · Ephrata, WAThe glider plt was maneuvering for a thermal when he encountered a downdraft. The plt said insufficient altitude remained for an airport landing. An off-airport landing on rough terrain resulted in damage to the glider.Jun 20, 1988 · CGHGZ · Substantial damageNTSB NYC88DFA02Accident · 1 fatalFinal reportTerry Tierra II · Plattsburgh, NYAccording to witnesses, the plt was on his 2nd flt of the day in a recently purchased ultralight type of acft. They rprtd that after the acft took off from rwy 32, it climbed to about 300' AGL & rolled into a steep right bank. Its nose then dropped & the acft…Jun 20, 1988 · N4462T · Substantial damageNTSB MIA88FA201Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Catano, PRAs the acft was taxiing for takeoff, witnesses noted the l rear baggage door was unlocked & hanging down. A warning was relayed to the plt via the twr, but by then the acft was airborne & the plt had rprtd a control prblm. Drg lift-off, theacft pitched up…Jun 20, 1988 · N90360 · DestroyedNTSB LAX88LA228Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Clearlake, CAThe pilot reported the airplane's right wing struck a swell during takeoff from a lake. The surface winds, however, were out of the southwest at 10 knots. The pilot had not flown within the preceding 24 calendar months. There were no reported airplane…Jun 20, 1988 · N6026V · Substantial damageNTSB LAX88LA227Accident · No injuriesLimited investigationFinal reportCessna 210M · Tres Pinos, CAJun 20, 1988 · N732KS · Substantial damageNTSB LAX88LA205Accident · No injuriesLimited investigationFinal reportCessna 150J · Calistoga, CAJun 20, 1988 · N61175 · Substantial damageNTSB LAX88DVG05Accident · No injuriesFinal reportSchweizer G-164B · Gridley, CAJun 20, 1988 · N8487K · DestroyedNTSB CHI88LA136Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC2-MK I · Warroad, MNThe pilot decided to land in the lake approximately 1000 yds from the sea plane base and was attempting a step-taxi back to the base when the acft struck a sand bar. The pilot stated that he was taxiing near tall grass where he thought the water was deep…Jun 20, 1988 · N49771 · Substantial damageNTSB CHI88DER10Accident · No injuriesFinal reportAnderson-Tucker Evans VP-1 · Duquette, MNOn the initial flight of this amateur built aircraft the pilot lowered the nose after liftoff to allow the aircraft to accelerate. However, the aircraft settled and the pilot was unable to keep the aircraft from colliding with trees.Jun 20, 1988 · N17BL · Substantial damageNTSB ATL88LA196Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Boston, GAThe pilot was attempting to land following a reduction in power when he overshot the runway. The pilot said the engine did not quit and was still producing thrust. The aircraft was destroyed by fire after it came to rest. The plt landed downhill and downwind.Jun 20, 1988 · N8371T · DestroyedNTSB MKC88LA113Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Florence, MOWhile on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss.Jun 19, 1988 · N94045 · Substantial damageNTSB MIA88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Coldwater, MSThe physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…Jun 19, 1988 · N95056 · Substantial damageNTSB MIA88LA198Accident · No injuriesLimited investigationFinal reportHughes 369D · Horn Lake, MSBfr tkof, the helicopter was svcd with 100LL fuel (an approved altn fuel if the boost pump is used in flt). Drg flt, theeng lost pwr. An autorotation was made in tall vegetation, but drg the lndg, the main rotor blades severed the tail boom. An inspn of the…Jun 19, 1988 · N1109P · Substantial damageNTSB LAX88LA225Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Santa Barbara, CAJun 19, 1988 · N37354 · Substantial damageNTSB DEN88LA132Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Moriarty, NMThe pvt glider plt was completing a five hr endurance flight. During the turn from base to final, the glider encountered a 15 kt xwind and overshot the turn. The plt attempted to 'buttonhook' back toward the intended touchdown point. Witnesses stated that…Jun 19, 1988 · N143SS · Substantial damageNTSB CHI88LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILWhile landing at the completion of his first solo cross country instructional flight, the student pilot landed long and was unable to stop before the end of the runway. The student pilot stated that he selected the sod runway instead of the 2,550' x 29'…Jun 19, 1988 · N49207 · Substantial damageNTSB SEA88LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Orofino, IDPlt stated that due to encircling tstms, elected a precautionary landing at 1800-foot usfs (forrest service) emrrgency strip. Touchdown was long and go-around resulted in a stall/mush into the trees.Jun 18, 1988 · N62961 · DestroyedNTSB SEA88FA113Accident · Minor injuriesField investigationFinal reportBeech 58P · Bellevue, WAThe plt reported that 20 gallons of fuel was added on may 18 and stated this brought the main tanks up to near full (160 gal). Between that fueling and the acc a total of 6.0 hours were recorded and an additional 80 gallons of fuel was added. Records at the…Jun 18, 1988 · N17795 · DestroyedNTSB NYC88LA171Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Steep Falls, METhe Ercoupe 415C took off to practice touch and go's with a student pilot in the left seat and on the controls. In the right seat was a private pilot who was listed as a pilot rated passenger. Both occupants were co-owners of the aircraft. The student pilot…Jun 18, 1988 · N94037 · Substantial damageNTSB NYC88LA169Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Copake Falls, NYDuring a practice autorotation to an open field, the aircraft struck a wire that had not been observed. An attempt to fly over the wire was unsuccessful and the tail rotor and aft 1/3 of the tail cone was severed from the helicopter. A hovering autorotation…Jun 18, 1988 · N622SC · Substantial damageNTSB NYC88LA168Accident · No injuriesLimited investigationFinal reportCessna 305A · Colts Neck, NJDuring a banner pick up attempt, the tow rope became affixed to the main landing gear. The pilot was unable to release the banner and landed with it still attached. Upon landing roll out, the aircraft's tail rose abruptly and the propeller dug into the turf.…Jun 18, 1988 · N14418 · Substantial damageNTSB NYC88FA167Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Livermore Falls, METhe citabria 7GCBC was observed to make a loop. The left wing bent upward at the strut attach point as the aircraft was at the bottom of the loop and recovering to level flight. The aircraft was then observed to descend in a right spiral and not recover prior…Jun 18, 1988 · N4129Y · DestroyedNTSB MKC88LA112Accident · No injuriesLimited investigationFinal reportBeech D18S · St. Louis, MOArriving at his destination airport after a night 14 CFR 135 air taxi cargo flight, the main landing gear collapsed during roll-out causing substantial damage to the aircraft. Post accident investigation revealed a broken landing gear drag link, which caused…Jun 18, 1988 · N4234A · Substantial damageNTSB MIA88FA197Accident · 1 fatalField investigationFinal reportKennedy Skycycle 2 · Orlando, FLThe gyroplane was on a local demonstration flt. The passenger (pax) stated the plt took off, climbed to aprx 500 ft AGL,descended to aprx 20 ft AGL & maneuvered near observers. He said the plt then added power & initiated a 30 deg climb attitude. The pax…Jun 18, 1988 · N33KA · DestroyedNTSB LAX88DVA08Accident · Serious injuriesFinal reportSmith Model B Avid Flyer · Atwater, CADuring a local test flight, just after takeoff, the engine suddenly lost power and went to idle. The pilot made an off airport landing without incident. The pilot inspected the engine finding nothing unusual. The pilot attempted another takeoff to return to…Jun 18, 1988 · N249SJ · DestroyedNTSB DEN88LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ayr, NDJun 18, 1988 · N455Y · Substantial damageNTSB CHI88DEC03Accident · Minor injuriesFinal reportCessna 150 · Jackson, MITotal loss of engine power due to carburetor icing.Jun 18, 1988 · N5810E · Substantial damageNTSB BFO88LA055Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Capon Bridge, WVLoss of power because of carburetor ice which obstructed airflow to the engine. The aircraft nosed over on landing because of soft terrain and high grass. The pilot's failure to use carburetor heat is a contributing factor.Jun 18, 1988 · N1841E · Substantial damageNTSB SEA88LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Athol, IDPlt landed long to avoid potential conflict with truck waiting to cross rwy. The pilot stated he experienced a tailwind after touchdown. He initiated a go-around but contacted rough terrain in overrun before becoming airborne.Jun 17, 1988 · N7112E · Substantial damageNTSB NYC88FA166Accident · 2 fatalField investigationFinal reportBell 206L-1 · Springtown, PAWhile in cruise flight, ground witnesses observed the helicopter make two violent roll maneuvers followed by an in-flight breakup. Aircraft wreckage was spread over an area of approximately 10 acres. Examination of the wreckage revealed that the collective…Jun 17, 1988 · N114FH · DestroyedNTSB MIA88WA194Incident · No injuriesForeign investigationBoeing 747-100 · CuracaoJun 17, 1988 · N817FT · Minor damageNTSB MIA88IA196Incident · No injuriesIncident investigationFinal reportLearjet 24 · W. Palm Beach, FLThe acft departed fort lauderdale executive arpt on a 14 CFR part 91 positioning flight to pick up a patient in west Palm Beach FL, for a 14 CFR part 135 air ambulance flight to rochester new york. The plt stated that on landing the acft floated aprx 4000…Jun 17, 1988 · N29LA · Minor damageNTSB MIA88FA195Accident · 1 fatalField investigationFinal reportPiper PA-31-P · Miami Lakes, FLThe instructor (CFI), who survived, was flying the acft fm the rgt fnt seat while the owner/plt was in the left seat. The flt had progressed normally until the plts rtrnd to the arpt to lnd. Clnc was received to lnd on rwy 9L. According to the CFI, he lowered…Jun 17, 1988 · N560JB · DestroyedNTSB LAX88LA226Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-100 · Tau, AntarcticaThe captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…Jun 17, 1988 · N202RH · DestroyedNTSB FTW88LA122Accident · No injuriesLimited investigationFinal reportCessna 182R · Garden City, TXThe pilot was inspecting some areas to be sprayed and also a road to be used as an airstrip for his aerial spraying. After a low pass over the road at reduced power, he advanced the throttle but the engine would not respond. During the forced landing in rough…Jun 17, 1988 · N9836H · Substantial damageNTSB FTW88DRD09Accident · No injuriesFinal reportGrumman G-164A · Basile, LADuring or after lift-off, the right landing gear axle assembly separated from the landing gear leg when the mounting bolts sheared. During landing, the airplane ground-looped and then flipped to the inverted position.Jun 17, 1988 · N4243 · Substantial damageNTSB CHI88DER03Accident · No injuriesFinal reportCessna 172K · Mora, MNDrg flt, one of the plts demonstrated a negative 'g' maneuver by entering a climb, then making a 'push over' to a descent. He throttled back on the back side of the maneuver to maintain airspeed. When the throttle was readvanced, there was no eng response.…Jun 17, 1988 · N7499G · Substantial damageNTSB BFO88LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Reedville, VAAfter back-taxiing on the pvt airstrip, the plt made a 180 deg turn to line up for takeoff. During the turn the right main gear contacted a ditch in a tall grass area off the end of the rwy. The plt applied power to prevent the acft from becoming stuck in the…Jun 17, 1988 · N82836 · Substantial damageNTSB ANC88LA150Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Mekoryuk, AKThe pilot-in-command was herding reindeer for a native corporation and he and his passenger had to relieve themselves so they landed on the tundra and left the helicopter's engine and rotors operating. As they were exiting the helicopter, it shifted on the…Jun 17, 1988 · N9076D · Substantial damageNTSB MKC88LA111Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Scranton, ARShortly after takeoff from a 2400 foot sod strip, the PIC said the acft began to settle, although both engines were delivering takeoff power and RPM, and liftoff speeds were proper. The acft settled back to the runway and careened off on to the overrun…Jun 16, 1988 · N165SE · Substantial damageNTSB MIA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lake Wales, FLDuring takeoff from the grass strip, the left main landing gear and wingtip collided with runway lights & a fencepost. The acft was slow to climb. After clearing trees at the departure end of the rwy, the acft descended below treetop level, then continued to…Jun 16, 1988 · N4379A · Substantial damageNTSB CHI88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mattoon, ILUpon return from a local aerial photography flight, the pilot failed to ensure that the aircraft landing gear was extended, down and locked. When the aircraft touched down, the gear was only extended approximately 10%; it collapsed fully when it contacted the…Jun 16, 1988 · N8226P · Substantial damageNTSB ATL88DKG08Accident · No injuriesFinal reportSikorsky S-55B · Valdosta, GAJun 16, 1988 · N6489 · Substantial damage