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 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…NTSB 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.NTSB 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…NTSB ATL88DKG07Accident · No injuriesFinal reportGrumman G164A · Clanton, ALNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB LAX88LA182Accident · No injuriesLimited investigationFinal reportSlingsby T59D Kestrel 19 · Middletown, CANTSB 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…NTSB 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…NTSB DEN88LA108Accident · No injuriesLimited investigationFinal reportCessna 210L · St. George, UTNTSB 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…NTSB SEA88LA125Accident · No injuriesLimited investigationFinal reportCessna 177B · Ocean Shores, WADuring taxi for takeoff, plt misjudged clrnc between wingtip and mowing machine.NTSB 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…NTSB 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.…NTSB 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…NTSB 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…NTSB LAX88WA185Accident · No injuriesForeign investigationPiper PA 32RT-300T · Santa Ynes, MexicoNTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB ATL88IA171Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355-F · Reidsville, NCNTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.…NTSB 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.…NTSB 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…NTSB 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…NTSB LAX88LA178Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Sacramento, CANTSB 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…NTSB LAX88FA331Accident · 4 fatalField investigationFinal reportBeech B-35 · Ocotillo, CAInflight collision with terrain for undetermined reasons.NTSB 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.NTSB CHI88IA111Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Detroit, MI