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 LAX88LA183Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Reedley, CAThe aircraft climbed to about 800 feet AGL after takeoff when the engine began to run rough. The pilot said that the engine then 'quit and restart(ed)' several times. He said that insufficient power was available to remain airborne and he attempted a landing…May 16, 1988 · N23415 · Substantial damageNTSB CHI88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Charlotte, MIDuring touchdown in a slight right crosswind, the student pilot inappropriately applied right rudder pressure. The aircraft yawed to the right and left the sod runway, veering into a plowed field. The aircraft struck a furrow and nosed over.May 16, 1988 · N8800C · Substantial damageNTSB ATL88FA173Accident · No injuriesField investigationFinal reportSwearingen SA-226-TC · Atlanta, GADuring a visual approach to runway 27L, the airplane was landed gear up. Both the capt and f/o stated that the landing gear had been lowered over the outer marker and that they had observed three green lights and that the warning horn had not sounded prior to…May 16, 1988 · N1013G · Substantial damageNTSB ATL88DKG07Accident · No injuriesFinal reportGrumman G164A · Clanton, ALMay 16, 1988 · N48438 · Substantial damageNTSB SEA88LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Anacortes, WAAfter overflying the intended seaplane base landing area. The pilot, who had logged only 1 hour of fixed wing time in the previous 90 days, misjudged the necessary downwind leg length and landed with insufficient surface distance available to stop the…May 15, 1988 · N4723J · Substantial damageNTSB NYC88LA140Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Rochester, NYThe Luscombe 8E experienced a failure of the right main landing gear axle during a bounced landing. The failure occurred at the weld where the axle attaches to the landing gear strut. Examination of the fracture revealed a pre-existing crack that was not…May 15, 1988 · N2047K · Substantial damageNTSB MIA88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ocean Springs, MSThe instructor stated that they were on their third touch and go and had made a wheel landing, and just as she started to retract the flaps, the aircraft made an aprx 30 degree turn off the right side of the runway. She then stated that no matter how much…May 15, 1988 · N7682K · Substantial damageNTSB LAX88LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Carlos, CADuring a post maintenance test flight prior to sign off of an annual inspection, the engine quit and the pilot performed a forced landing in a mud field colliding with a dike. Examination of the engine revealed that a fuel pressure line had disconnected from…May 15, 1988 · N9601L · Substantial damageNTSB LAX88LA182Accident · No injuriesLimited investigationFinal reportSlingsby T59D Kestrel 19 · Middletown, CAMay 15, 1988 · N74T · Substantial damageNTSB FTW88LA102Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Floresville, TXThe engine stopped producing full power and the pilot had to make a forced landing in a pasture. During the landing roll, the airplane impacted a fence. The pilot said he found fuel in both tanks but the right tank had collapsed due to the tank vent being…May 15, 1988 · N2RD · Substantial damageNTSB FTW88DRD03Accident · 1 fatalFinal reportCessna 188 · Winnsboro, LAThe private pilot was practicing aerial application maneuvers with between 20 to 40 gallons of water in the spray tanks. A witness indicated that 'as the airplane started down for the pass it clearly went into a flat spin in which it made almost 2 full…May 15, 1988 · N78392 · DestroyedNTSB DEN88LA108Accident · No injuriesLimited investigationFinal reportCessna 210L · St. George, UTMay 15, 1988 · N732BR · Substantial damageNTSB ATL88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe plt landed the airplane long at an excessive airspeed. The airplane overran the rwy end, traveled across a grassy area onto a ramp area, and collided with a parked airplane. The plt had 2 hrs of flt experience in this make and model airplane, which was…May 15, 1988 · N8261L · Substantial damageNTSB SEA88LA125Accident · No injuriesLimited investigationFinal reportCessna 177B · Ocean Shores, WADuring taxi for takeoff, plt misjudged clrnc between wingtip and mowing machine.May 14, 1988 · N35177 · Substantial damageNTSB SEA88LA094Accident · 1 fatalLimited investigationFinal reportBellanca 7GCAA · Sutcliffe, NVThe aircraft was observed to execute several low passes over witnesses along the shoreline of a lake. During one of the passes and while tracking northwest, the pilot dropped a package of life preservers from an estimated altitude of 75 feet AGL and while…May 14, 1988 · N57415 · DestroyedNTSB SEA88FA095Accident · 1 fatalField investigationFinal reportCessna 172L · Ocean Shores, WAThe student pilot departed on his fifth solo flight from the airport where he had been accustomed to originating his instructional flights. After several touch and go landings he proceeded to a nearby airport and conducted at least one more touch and go.…May 14, 1988 · N7935G · DestroyedNTSB NYC88LA142Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Red Creek, NYWhile the pilot was waiting for liftoff, three ground crewmen were sitting on the basket holding the Balloon down. As the pilot prepared for liftoff, he announced that he was ready for liftoff and untied the rope. As the Balloon reached an altitude of about…May 14, 1988 · N1502K · No damageNTSB NYC88LA139Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chester, PAThe pilot was performing a touch and go landing at brandwyine airport and lost directional control during landing. He said he touched down, applied full power then remembered to put the flaps up. When the acft started to veer off the rwy the plt applied…May 14, 1988 · N9638B · Substantial damageNTSB LAX88WA185Accident · No injuriesForeign investigationPiper PA 32RT-300T · Santa Ynes, MexicoMay 14, 1988 · N79GH · Substantial damageNTSB LAX88LA186Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Merced, CAWhile taxiing on a dirt road, the right wing struck a tree resulting in substantial damage. There were no mechanical failures or malfunctions reported at the time of the accident.May 14, 1988 · N66SL · Substantial damageNTSB LAX88LA181Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Chino, CADuring a sightseeing flight, the engine suddenly quit and an emergency off-field landing was made. During the landing roll, the aircraft collided with a fence. The pilot had been operating the aircraft off of the left fuel tank. The left fuel tank was found…May 14, 1988 · N46836 · Substantial damageNTSB LAX88FA180Accident · 3 fatalField investigationFinal reportCurtiss-Wright Travel AIR 2000 · Fairfield, CAPilot's failure to maintain an airspeed at which the aircraft is controllable and entering a stall.May 14, 1988 · N6130 · DestroyedNTSB FTW88LA101Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Dalhart, TXThe local flight was circling at low altitude and reduced airspeed over farm equipment and level farmland while the passenger in the rear seat took photographs. The passenger in the right front seat said he heard the stall warning horn just prior to the…May 14, 1988 · N6069J · DestroyedNTSB BFO88LA048Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mathew, VAThe plt stated he did a soft field takeoff using 10 degs of flaps. The acft lifted off at about 55 to 60 KTS but according to the plt, was unable to climb out of groundeffect. Since he was too FAR down the rwy to abort the takeoff the plt increased pitch to…May 14, 1988 · N6449R · Substantial damageNTSB BFO88FA047Accident · Minor injuriesField investigationFinal reportCessna 310L · New Cumberland, WVThe plt was doing low passes down rwy 04 when according to the plt he struck a large bird after the second pass just when he was starting to climb about one-half mile from the rwy end. The plt said that the bird shattered the windscreen causing the plt facial…May 14, 1988 · N2220F · DestroyedNTSB ATL88FA174Accident · 4 fatalField investigationFinal reportMooney M20F · Middlesboro, KYWitnesses rprted the eng did not sound like it was providing full power drg takeoff & that abt 3/4 of the 3600' rwy was used for the takeoff roll. After lift-off, the acft climbed at a shallow angle to abt 250 to 300 ft AGL. It then entereda shallow left…May 14, 1988 · N9654M · Substantial damageNTSB ANC88FA056Accident · No injuriesField investigationFinal reportCessna U206 · Anchorage, AKA deaf-mute adult male, who has a history of mental health problems, and who was a mental health ward of the state of Alaska at the time of the accident, entered a Cessna 206 airplane equipped with amphibious floats without permission while it was parked on…May 14, 1988 · N4844X · Substantial damageNTSB NYC88LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Millbrook, NYThe aircraft departed runway 17 at sky acres airport and after reachng an altitude of about 100 feet, witnesses observed the engine cowling extended vertically, partially attached. The pilot said he was unable to return to the departure airport, and the…May 13, 1988 · N2819J · Substantial damageNTSB MIA88LA169Accident · Serious injuriesLimited investigationFinal reportBoeing HP-B-377 · Miami, FLAccording to company personnel, as the acft rotated for takeoff, one generator tripped off the line. Then as the landing gear was selected up, the other three generators simultaineously tripped off. The acft was flown on an extended pattern while the crew…May 13, 1988 · HI468 · No damageNTSB LAX88LA179Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Waialua, HIFailure to follow procedures established by the manufacture for uncommanded trim inputs and his decision to make a hover approach to landing.May 13, 1988 · N4943T · DestroyedNTSB FTW88FA100Accident · Serious injuriesField investigationFinal reportCessna 172F · Golden, TXAcft was operating on an aerial photography flt at 200 to 500' AGL and 70 to 80 mph. The commercial plt stated that as he was in a bank the acft seemed to be 'pushed' into the 60 to 80' trees over which he was flying and that it 'fell out of the air'. He also…May 13, 1988 · N5577R · DestroyedNTSB DEN88FA107Accident · 2 fatalField investigationFinal reportStinson 108-2 · Mosca, COAfter purchasing acft, plt and plt-rated friend (both airline plts) were joined by plt's wife and departed falcon field, mesa, AZ, en route to MN. The trio stopped in alamosa, CO, for night. They departed alamosa (elevation 7608 ft MSL) the next morning and…May 13, 1988 · N354C · DestroyedNTSB ATL88LA172Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mocksville, NCThe floatplane student pilot lost control of the aircraft during a practice glassy water take off. The floatplane instructor did not take control soon enough and the aircraft stalled and struck the water.May 13, 1988 · N9674P · Substantial damageNTSB ATL88IA171Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355-F · Reidsville, NCMay 13, 1988 · N101UC · Minor damageNTSB SEA88LA093Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Prineville, ORThe pilot reduced power for landing and a high sink rate developed. The pilot attempted to increase power to correct the sink rate but got no response. Rotor rpm's were diminishing, so the plt lowered the collective to regain rpm's. the pilot elected make an…May 12, 1988 · N751AM · Substantial damageNTSB NYC88FA143Accident · Minor injuriesField investigationFinal reportBell 206B · Farmingdale, NYThe Bell 206B was being flown on a helicopter rating ride with the PIC in the right seat and an FAA inspector in the left seat. The oral was satisfactory and the flight check progressed to autorotations. The first one was long, the second short. On the third…May 12, 1988 · N39071 · Substantial damageNTSB MKC88LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Concordia, KSWhile attempting a crosswind landing, PIC decided to make a go-around. During the go-around the acft stalled, struck the terrain and cartwheeled.May 12, 1988 · N8240B · Substantial damageNTSB FTW88LA099Accident · No injuriesLimited investigationFinal reportBeech B55 · Ada, OKThe plt said all pre-flt prep were normal including an eng run-up. The takeoff was being made with light winds. After rolling about 300 ft the acft began a swerve to the rt which the plt perceived was associated with a loss of pwr on the rt eng. The plt…May 12, 1988 · N7330R · Substantial damageNTSB DEN88DTI01Accident · No injuriesFinal reportJudge Q2 · Cut Bank, MTThe acdt occurred on the arpt when the plt decided to abort the flt shortly after takeoff. The plt said that after takeoff the acft did not seem to accelerate properly so he decided to land. The takeoff had been made on a 5300 ft long rwy which has a 600 ft…May 12, 1988 · N31DJ · Substantial damageNTSB CHI88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Nauvoo, ILThe pilot was making a 'fast low approach' to a private airstrip near his home when he realized he was coming too close to a row of trees. The pilot stated he became so preoccupied with trying not to hit the trees that he did not notice how close the aircraft…May 12, 1988 · N757ZY · DestroyedNTSB BFO88FID03Accident · Serious injuriesFinal reportPiper PA-38-112 · Chesapeake, VAThe pilot was doing touch & go landings. During climbout engine power loss occurred at an estimated 300 ft AGL. The pilot radioed mayday and a witness stated he heard the stall horn during the transmission. Afterwards the acft pitched down and spun to the…May 12, 1988 · N2601C · DestroyedNTSB BFO88FA046Accident · Minor injuriesField investigationFinal reportPiper PA-28-180 · Arlington, VAThe acft had a total loss of eng power about 7 miles short of the destination necessitating a forced landing in a schoolyard. The acft had been flown about 4.4 hrs since it was last refueled. Examination of the acft revealed less than a gallon of fuel aboard.…May 12, 1988 · CGGNH · Substantial damageNTSB SEA88LA091Accident · No injuriesLimited investigationFinal reportCessna 150K · Yamhill, OROn short final for landing onto a 2100 foot airstrip at about 12 feet AGL, the aircraft encountered adverse winds and struck the ground in a three point attitude breaking off the nose gear. The aircraft then nosed over inverted striking a barbed wire fence.…May 11, 1988 · N6251G · Substantial damageNTSB MKC88DCJ01Accident · Serious injuriesFinal reportCessna A188B · Dalton, NEThe pilot was spraying a large field which had a power line along the north side. On the 1st couple of passes, the spray equipment had intermittent malfunctions. As the aircraft approached the field from north for the 4th pass, it struck the upper cable of…May 11, 1988 · N70135 · DestroyedNTSB MIA88IA168Incident · No injuriesIncident investigationFinal reportPiper PA-42-720 · Chicago, ILCondor flt 610 (Mcdonnell Douglas DC-10, german registration: dadso) was aprx 2 hrs late as the flt crew members were preparing to takeoff. Subsequently, flt 610 was clrd for takeoff with instructions to cross the 5 DME (on the standard instrument…May 11, 1988 · N900MP · 2 aircraft · No damageNTSB LAX88LA178Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Sacramento, CAMay 11, 1988 · N747JR · Substantial damageNTSB LAX88LA177Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Temecula, CADuring the landing roll in a direct crosswind, the aircraft began to weather vane. The pilot was unable to maintain control of the aircraft which veered off the runway where it collided with the terrain and nosed over. There were no reported mechanical…May 11, 1988 · N9570K · Substantial damageNTSB LAX88FA331Accident · 4 fatalField investigationFinal reportBeech B-35 · Ocotillo, CAInflight collision with terrain for undetermined reasons.May 11, 1988 · N8875A · DestroyedNTSB FTW88DRD02Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe ag airplane was spraying over a rice field and was making a turn-around when the airplane settled into small trees and bushes. No problems were found with the airplane or powerplant.May 11, 1988 · N4708 · Substantial damageNTSB CHI88IA111Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Detroit, MIMay 11, 1988 · N9014U · No damage