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 ANC88LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKWitnesses stated that acft #1 (N2747P,a Piper PA-22), flew a right downwind about 200 feet above the ground and then made a steep descending turn toward the runway. Acft #1 landed and struck acft #2 (N9102D, a Piper PA-18) while both were on the runway. The…NTSB NYC88LA180Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Lakewood, NJLoss of directional control during landing, due to a banner towing rope being wrapped around the left rudder horn.NTSB NYC88LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Fryeburg, MEAccording to witnesses, the pilot had been drinking and two friends drove him to the airport and watched as he departed. They noted that the aircraft was climbing steeply after liftoff and then observed the aircraft's rotating beacon as the aircraft spiraled…NTSB FTW88DRD12Accident · No injuriesFinal reportTexas Helicopter M74C · Rayville, LAThe commercial pilot was spraying his cotton field with his own helicopter. The acft hit a tree during a right turning pull-up. The tail rotor blades were severed first then, during an uncontrolled right turn, the tailboom hit another tree. The main rotor…NTSB DEN88LA153Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Spearfish, SDThe accident involved a tri-pacer with four persons and about 150 pounds of baggage on board who were from Canada and vacationing in the U.S. The pilot said the acft became airborne and climbed to about 100 ft above the rwy, but would not maintain altitude…NTSB CHI88FA163Accident · No injuriesField investigationFinal reportBoeing 727 · St Paul, MNAfter push back from the gate, the captain received an unrestricted taxi clearance & elected to taxi to the north side of a construction area. Subsequently, the left wing of the acft struck a parked vehicle in a nonmovement area, which resulted in substantial…NTSB CHI88DEX08Accident · No injuriesFinal reportContinental Copters Tomcat MK-6 · Straughn, INAerial application helicopter struck power lines in field on first swath run. This was the first time the pilot had sprayed this field. Prior to spraying the field he questioned the farmer regarding power lines or other obstructions. The farmer replied that…NTSB CHI88DEP05Accident · No injuriesFinal reportGriffin Pitts S-1S · Rio, WIWhen the pilot of the amateur built biplane initiated a go-around from a VFR approach, he found that he had no response to throttle application. He then executed an intentional forced landing in an adjacent field. During this landing the aircraft collapsed a…NTSB CHI88DEE05Accident · No injuriesFinal reportWeatherly 620 · Dekalb, ILAn on ground encounter with weather.NTSB CHI88DEC05Accident · No injuriesFinal reportBell 47D1 (OH-13E) · Stockbridge, MIThe plt was spraying an onion field when he noted a vibration, followed by a loud noise & severe shaking of the helicopter. He attempted a forced landing, but the helicopter was unresponsive to cyclic & collective inputs. Subsequently, the right skid dug into…NTSB ANC88LA090Accident · No injuriesLimited investigationFinal reportCessna A185F · Georgetown, AKThe pilot stated that he encountered several up & down drafts prior to lndg. After landing and taxiing toward shore, the pilot saw the surface water on the river being whipped up; the pilot estimated the wind to be 40 knots or more. The aircraft became…NTSB NYC88LA178Accident · No injuriesLimited investigationFinal reportChampion 7GBC · Staten Island, NYThe pilot stated that after flying into a thunderstorm he encountered strong turbulence, heavy downdrafts and rain, which forced him into the water. When he realized that he was going down he dropped the banner he was towing 'but the airplane didn't want to…NTSB MKC88LA123Accident · No injuriesLimited investigationFinal reportAeronca 7EC · St. Charles, MOThe plt said he was taxiing out for departure, when he collided with another aircraft that was taxiing in from a local flight. He said he was intending to make an intersection takeoff and failed to see the incoming aircraft in time to avoid a collision.NTSB FTW88FA132Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Electra, TXThe private pilot's logbook indicated he had a checkout on steep turns and spins two months prior to the accident. He also logged four landings during the same one-half hour flight. A witness saw the airplane complete a three turn spin and saw it start to…NTSB DEN88FA151Accident · Serious injuriesField investigationFinal reportAerospatiale SA-315B · Dubois, WYNTSB CHI88LA164Accident · No injuriesLimited investigationFinal reportCessna 210M · Indianapolis, INThe pilot reported that he was on his way back from another local airport. He thought that he had lowered the gear when he had entered the traffic pattern. The aircraft landed gear up. Post-accident exam disclosed no mechanical failures or system malfunctions…NTSB CHI88FA162Accident · 1 fatalField investigationFinal reportCessna 172M · Holland, MIPilot's inadequate aircraft handling during the approach to landing and landing flare phase of flight. The pilot's failure to recognize and avoid a situation from which it was impossible-due to the weight of the aircraft, the amount of power available from…NTSB BFO88LA066Accident · Serious injuriesLimited investigationFinal reportBalloon Works AX-8 · Purcellville, VAThe pilot landed the hot air Balloon at an excessive descent rate which resulted in a hard landing. Wind gust are a contributing factor.NTSB ATL88LA212Accident · Minor injuriesLimited investigationFinal reportCessna 310 · New Bern, NCThe plt rptd the lt engine lost pwr on 'very short final'. Shortly thereafter, he heard the stall warning. The airplane rolled and yawed left, and crashed nose-down short of the rwy. The acft was examined the next day by an FAA inspector; he rptd finding no…NTSB ATL88DKG09Accident · 1 fatalFinal reportCessna 188 · Garfield, GAFollowing minor engine maintenance, the plt/mechanic made the test flight. The engine cowling was not installed prior to the flt. Witnesses reported that the acft wheels touched the water of a nearby pond followed by a sharp pull-up into the plt's customary…NTSB ANC88LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKAfter touchdown on the airstrip the pilot lost control of the airplane. The airplane bounced. The airplane then exited the left side of the runway into a row of trees.NTSB ANC88LA087Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Quartz Creek, AKAccording to the flight instructor, he and the student pilot attended a picnic and were returning. During the departure, and while attempting a step taxi turn, they struck the trees along the shoreline.NTSB SEA88LA133Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAOn the first leg of the scheduled float plane flight the plt had landed on lake union to embark addl pax. As the acft decelerated 'off the step,' a power boat converged on acft path. Plt made rudder input to avoid collision and wingtip contacted water.NTSB NYC88LA179Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHThe plt reported that the eng lost power during takeoff as the acft was climbing thru about 200 to 250 ft AGL. Unable to restore power, he turned to land in a corn field, but was unable to reach it. He then selected a smaller field, but during the landing,…NTSB MKC88LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Topeka, KSWhile taxiing in from a personal solo training flight, the student pilot taxied into a chain link fence while attempting to park the acft. The right wing spar sustained substantial damage.NTSB MKC88LA121Accident · No injuriesLimited investigationFinal reportBeech A-60 · Lexington, MOThe pilot failed to provide the aircraft with a fuel supply adequate to complete the proposed flight and the pilots failure to maintain directional control of the aircraft during the landing roll on the active runway.NTSB MKC88DCG01Accident · Serious injuriesFinal reportBoeing 75A · Neosho, MOWitnesses stated that just after liftoff, they observed a map blow out of the a/c. the pilot stated he saw something go past and turned to see what it was. He inadvertently pushed the stick forward and hit the runway nose-first. The pilot stated that he was…NTSB LAX88LA250Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Palo Alto, CADuring a local flight, the pilot noted that the oil pressure was low. En route to the airport, the engine quit. A forced landing was made on a road where during the landing the airplane collided with telephone wires and subsequently the terrain. Inspection of…NTSB LAX88FA249Accident · Minor injuriesField investigationFinal reportHughes 269C · Van Nuys, CAFlight with undertorqued rotor dampers.NTSB LAX88DUM04Accident · Minor injuriesFinal reportHiller UH-12D · Winterhaven, CANTSB FTW88IA129Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Abilene, TXThe airplane touched down on the main wheels, bounced, then touched down on the runway with all three landing gear retracted with the gear doors closed. During the investigation, no electrical, mechanical, or hydraulic malfunctions could be found. The landing…NTSB DEN88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aurora, COThis was the student pilot's first solo landing. She said the acft drifted to the left of the centerline during the landing roll and she attempted to correct with right rudder. However, the acft continued to the left and ran off the left side of the rwy. The…NTSB DEN88LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Erie, CONTSB ANC88LA086Accident · No injuriesLimited investigationFinal reportHughes 369D · Kitoi Bay, AKThe helicopter landed with the left skid against a survey stake which protruded from the ground about 6 inches. Upon liftoff the skid did not clear the metal stake before the helicopter started moving laterally to the left. The left skid remained against the…NTSB ANC88LA085Accident · 1 fatalLimited investigationFinal reportMaule M6-235 · Egegik, AKAfter touchdown on the beach, the aircraft struck a three-wheeled scooter (atv). The atv was substantially damaged and the driver of the atv, an eleven year old boy, died a few days later. The atv passenger, a eight year old girl, received minor injuries.…NTSB ANC88LA084Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot of a Cessna 170 lost directional control and ground looped while taxiing for take off. The FAA control tower had instructed the pilot to taxi behind a taxiing B-727, and issued caution: wake turbulence. The idle power of the B-727 caused the Cessna…NTSB SEA88LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Roche Harbor, WAPlt was attempting no flap landing on down-sloping narrow runway in variable and gusty wind conds. Hard landing resulted in departure from hard surface, encounter with parallel ditch and rock, and noseover.NTSB MKC88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Marion, IAWhile attempting to land after one go-around. Witnesses said the acft touched down beyond the half way point on the 2300 foot sod runway. He appeared to be high and fast according to witnesses. The pilot said he might have mistaken the threshold and landed…NTSB MIA88LA218Accident · No injuriesLimited investigationFinal reportCessna 150F · Plymouth, FLThe student pilot was on a solo instructional flight. The winds were reported to him as a 20-30 degree crosswind at 15 knots gusting to 20. The student pilot lost control of the acft. The right wing contacted the runway, then the acft nosed over. The pilot…NTSB DEN88LA149Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Cheyenne, WYThe flight originated in omaha, NE. Three passengers and the commercial plt embarked on a fishing trip into Wyoming. The pilot departed Cheyenne after having several problems with the engine and correcting the problem by proper leaning. He said he took off…NTSB CHI88LA161Accident · No injuriesLimited investigationFinal reportCessna 170B · Rockford, ILNTSB CHI88DEX07Accident · Minor injuriesFinal reportCessna 175A · Bloomington, INAircraft experienced partial loss of engine power at 150 feet AGL after takeoff. Pilot made 180 degree turn in attempt to return to airport, but experienced further power loss and elected to make emergency landing in field. Right wingtip hit tree, and…NTSB MKC88LA129Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Baker, MOWitnesses said that shortly after takeoff, the fully loaded acft appeared to be unable to climb out of ground effect. About 1.5 mile from the airstrip, the pilot began a turn back to the north. Unable to climb, he initiated action to dump his chemical load,…NTSB MKC88FA119Accident · 4 fatalField investigationFinal reportCessna 320 · Atwood, KSThe PIC had deptd the denver metro area carrying pax to vacation in Indiana. No flt plan was filed and there was no record of a preflt wx brief. The flt progrsd without any known difficulty until reaching the colorodo/kansas border. The PIC rqstd and rcvd wx…NTSB DEN88LA148Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Craig, COWhile on final after a 4.6 hr x-cnty flight, the pilot reported that the engine quit. The plt said that the engine probably failed due to fuel exhaustion. Personnel at the wreckage site reported no fuel was found in the fuel tanks. After the engine failed,…NTSB CHI88LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Moraine, OHWhile on final approach N7222W experienced a midair collision with N8611U on a similar approach. N8611U was a high wing aircraft and was in front of and below N7222W which was a low wing aircraft. The pilot of N8611U stated that he had no knowledge of the…NTSB CHI88LA155Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Hillsboro, OHAfter making a low pass down a private strip, the aircraft experienced a wire strike followed by an uncontrolled descent into the ground. The pilot stated that his attention was diverted by the owner of the strip.NTSB CHI88IA157Incident · No injuriesIncident investigationFinal reportBeech C99 · Indianapolis, INComponent failure due to improper lubrication by the operators maintenance personnel.NTSB CHI88FA160Accident · 1 fatalField investigationFinal reportCessna 172N · Middletown, INAttempted operation of the accident airplane by the PIC when he was under the influence of alcohol.NTSB ATL88FA211Accident · Serious injuriesField investigationFinal reportCessna 175 · Ninety Six, SCThe pilot was cruising the airplane at 2,000 feet AGL when he noted a loss of oil pressure and increase in oil temperature. He also noted a loss in engine power. He elected to make a landing off airport and set up a pattern for the selected field. The…