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 ATL86LA161Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Guntersville, ALThe plt allowed the aircraft to settle back onto the runway shortly after liftoff from the runway after having already retracted the landing gear. The aircraft landed with the landing gear retracted.NTSB ATL86IA162Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Charleston, SCDuring a scheduled air carrier flight at normal cruising altitude, the captain passed out upon re-entering the cockpit after excusing himself to go to the lavatory. The flight crew diverted to an alternate destination due to the medical emergency. A review of…NTSB ATL86FA160Accident · Serious injuriesField investigationFinal reportBeech D45(T34B) · Rome, GAJust before takeoff, a rain shower was observed approaching the arpt. The plt elected to make a maximum performance takeoff. Rprtdly, after lift-off. She initiated a climb at 70 KTS & raised the flaps. The plt reported beginning a shallow turn at aprx 200 ft…NTSB SEA86LA147Accident · No injuriesLimited investigationFinal reportAvian Skyhawk · Yakima, WAA forced landing was made due to fuel starvation. During the forced landing the balloon struck power lines, severing the basket from the envelope. Sparks from the wire strike caused a small brush fire. Post accident exam revealed the plt inadvertently…NTSB SEA86LA141Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCM-12D-85 · Ketchikan, AKThe plt felt a sudden hard jolt while in cruise flt. The acft assumed a nose low, left wing down attitude which the plt was unable to correct by use of power and control inputs. The acft was at a low altitude due to weather. The acft impacted the water in a…NTSB SEA86LA140Accident · Minor injuriesLimited investigationFinal reportVarga 2050A · Bear Trap, IDDuring a simulated forced landing the instructor pilot allowed the student to enter into a stall while turning from base to final. Although the instructor attempted to correct the student's mistakes he allowed the student to go too FAR with the task before…NTSB MKC86LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hickory Ridge, ARThe plt stated that the takeoff was normal up to the initial climb when, at this point oil began streaking from the engine and it lost power. According to the plt, he immediately tried to dump the fertilizer and look for a place to land but, due to the…NTSB LAX86LA245Accident · Minor injuriesLimited investigationFinal reportFairchild 24R-40 · Marysville, CAThe acft's left wing spar failed while the acft was in level flt. The plt was able to regain partial control of the acft and landed it in a plowed field. The acft owner reported he had previously replaced the right wing due to deterioration of the wood…NTSB LAX86FVA08Accident · Serious injuriesFinal reportNelson/Nelson Varieze · Merced, CAWhile on final approach witnesses observed the aircraft to be low and slow when the wing collided with a light stanchion (5' high). The left wing banked sharply to the left, hit the ground and the acft cartwheeled. The pilot reported no mechanical problems…NTSB LAX86FA247Accident · Serious injuriesField investigationFinal reportBeech M35 · Swall Meadows, CAThe civil air patrol (cap) organized & provided instructors to teach cap mission plts techniques of 'high altitude' search flying during a 2-DAY course. The curriculum included making a landing approach to a 6080 ft elevation airstrip. The approach was to be…NTSB FTW86FPJ08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Blackwell, OKThe acft crashed after a turn while spraying a field. The acft caught fire after the impact but the plt escaped.NTSB DEN86LA157Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Williston, NDPlt stated that he was unfamiliar with the geographical area on this flt. He also stated, 'I was paying attention to the pwr lines and road and did not realize the hill out front was as high as it was...I attempted to turn back out, but with downwind it blew…NTSB CHI86FA151Accident · No injuriesField investigationFinal reportBeech 55 · Kenosha, WIThe acft was on a positioning flt returning from traverse city, MI, to Kenosha, WI. The reported milwaukee weather was ceiling 300 ft and visibility 2 miles. The pilot was cleared for a VOR 14 approach and given vectors to the final approach course. The pilot…NTSB ATL86LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Magnolia Spring, ALDuring a spray run the plt attempted to climb over a tall tree, the acft failed to clear the tree which was contacted with the right wing. The acft then crash landed in a field. The acft was observed to stagger during several turns earlier in the operation.…NTSB ATL86LA159Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fayetteville, GAThe plt reported that while on downwind the engine started to run rough. The plt applied carburetor heat and the engine quit. A turn toward a landing area was made; however, the acft collided with trees. Weather conditions at the time were favorable for…NTSB NYC86MA148Accident · 4 fatalMajor investigationFinal reportSikorsky S-76B · Sutton, MAAbout 16 min after takeoff, while cruising at 6000' MSL in IMC, the plt transmitted 'Sikorsky 507' (call sign of acft hefrequently flew). The ATC ctlr was talking to another flt & did not respond. About 1 min later, rdo & radar contact werelost & the…NTSB MIA86LA173Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Ormond Beach, FLThe plt stated that the acft engine lost oil pressure. He then dropped the banner, & ditched the acft in the ocean. Post crash examination revealed that the loss of oil pressure was due to oil starvation. No evidence of oil seepage was noted on or near the…NTSB LAX86LA253Accident · Minor injuriesLimited investigationFinal reportHall Christen Eagle II · Long Beach, CAWhile practicing touch & go takeoffs and landings on runway 25R at Long Beach international arpt, Long Beach, CA, the acft experienced a total engine power loss. The PIC was flying from the rear seat and reptd the acft altitude was insufficient to return to…NTSB LAX86LA242Accident · 1 fatalLimited investigationFinal reportHiller UH-12E · Thermal, CAThe helicopter collided with terrain during a maneuvering turn while applying a pesticide to a cultivated field. The acft was seen on the pass just prior to the accident and the acft appeared to be lower than usual. The acft was destroyed by post-impact fire.NTSB DEN86LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Cheyenne, WYThe student plt flew from alliance to Cheyenne on his solo x-country and flew locally at Cheyenne to make 3 landings at a twr controlled arpt. While he was in the pattern a cumulonimbus cloud moved into the vicinity of the arpt and the winds became gusty.…NTSB DEN86LA155Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Vernal, UTWhile flying a pipeling patrol flt 1,000 feet AGL in mountainous terrain, the plt encountered a downdraft windshear which resulted in an uncontrollable 2,000 fpm acft descent from which the plt was not able to recover. The acft impacted in rough terrain and…NTSB DEN86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Harve, MTAccording to the plt, shortly after takeoff the eng lost partial pwr as a result of carb ice, & a forced landing was made.NTSB DEN86LA153Accident · No injuriesLimited investigationFinal reportCessna 172G · Charlson, NDAccording to the plt, he lndd in an off arpt field to make a rest stop. He stated that bfr taking off again, he checked for wind & fnd none. He then initiated a soft field takeoff twd the NE with 20 deg of flaps. He stated that after lift-off, he 'took some…NTSB CHI86FER10Accident · 2 fatalFinal reportAeronca 65-TAC · White Bear Lake, MNThe acft stalled & crashed following the initial takeoff. Witnesses stated that the plt aborted the 1st takeoff attempt. During the 2nd takeoff witnesses said that the acft nose was never lowered from a nose high position. After the acc the elevator trim was…NTSB BFO86FID07Accident · No injuriesFinal reportCessna 172M · Lynchburg, VAThe accident occurred as the plt was attempting to land at an unfamiliar arpt during a x-country flt because a passenger was feeling ill. The rwy was 2900 ft long with a 5% upslope at mid-field. The plt stated he misjudged his alt and airspeed during the…NTSB ANC86IA066Incident · No injuriesIncident investigationFinal reportCessna 207 · Manokotak, AKDuring cruise flight the engine began to run rough. The pilot attempted switching fuel tanks but the engine continued to run rough. The engine ceased operation and did not windmill during the emergency descent. An examination of the engine later revealed that…NTSB SEA86LA136Accident · No injuriesLimited investigationFinal reportCessna 185 · Boise, IDDuring rollout after landing, the pilot was asked by the tower to expedite clearing the runway due to landing traffic. As the aircraft had slowed, the pilot attempted a turnout when a groundloop occurred. A gust of wind precipitated the groundloop. The wind…NTSB NYC86FA140Accident · 2 fatalField investigationFinal reportAeronca 7AC · Chaumont, NYThe pilot departed his private strip and crashed about 5 minutes later in a steep nose down attitude. Over 50 per cent of the fluid in the carburetor was a contaminant.NTSB LAX86LA241Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Sonoma, CAThe acft collided with a pole and crashed in a flooded field while on final approach. The pilot indicated that he flew a 20 minute local VFR flight prior to the accident. He stated he had suffered head injuries and was unable to recall any details of the…NTSB FTW86LA105Accident · No injuriesLimited investigationFinal reportMaule M7-235 · New Orleans, LAThe plt lost directional control of the acft during the landing roll when he failed to compensate adequately for the x-wind resulting in a ground loop.NTSB FTW86FRG25Accident · 1 fatalFinal reportAero Commander S2R · La Feria, TXThe acft contacted guy wires which supported a 1000 ft high television tower. Impact with the wires occurred at an alt of aprx 300 ft.NTSB FTW86FRG24Accident · No injuriesFinal reportGrumman G-164 · La Feria, TXAs the plt was making a swath run, he started to cross under power lines, but saw the profile view of a road marker. When he pulled up to avoid the road marker, the acft struck the wires, rolled to the left & collided with the ground.NTSB DEN86LA152Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sisseton, SDThe front seat plt, on his first flt in the acft, was flying the acft. After takeoff the acft entered a nose high attitude because the elevator trim was improperly set. The nose high attitude was corrected but the right door on the engine cowling came open…NTSB BFO86LA033Accident · No injuriesLimited investigationFinal reportCessna 152-II · Gaithersburg, MDWith the wind out of the east at about 10 knots, the student pilot touched down on the centerline of runway 32. Shortly thereafter, the aircraft swerved right and then left and the CFI attempted to take over the controls. She stated that she could not…NTSB BFO86FID06Accident · Minor injuriesFinal reportAyres S2R · Virginia Beach, VAThe acft was ditched after a loss of power during takeoff. Plt was unable to maintain alt & dumped liquid fertilizer load prior to landing. After ditching in a shallow canal the acft nosed over. Post accident investigation revealed a cracked cylinder in the…NTSB ATL86LA268Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roanoke, ALReportedly, during the landing roll, the acft went off the right side of the rwy and continued across a shallow ditch and down an embankment. The plt stated that the acft did not RESP0ND to control and brake inputs to correct the swerve in calm winds. The FAA…NTSB ATL86LA157Accident · No injuriesLimited investigationFinal reportMooney M20E · Pell City, ALThe eng lost pwr and a forced landing was made aprx 5 miles south of the destination arpt. The plt reported that, prior to departure he visually examined the fuel tanks and estimated having aprx 9 gals total fuel onboard. He estimated that only 5 gals would…NTSB ANC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot stated that after the landing roll, directional control of the aircraft was lost causing the aircraft to exit the left side of the runway striking an airport sign.NTSB NYC86LA147Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lenox Township, PAThe Cessna 152 experienced a power loss while being flown by a student pilot. During the forced landing the aircraft struck a utility pole and received substantial damage. The pilot was uninjured. Examination of the aircraft by the FAA showed the fuel tanks…NTSB NYC86LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PADuring takeoff roll and as the aircraft was brought to full power, the flight started to veer left. Attempts to correct with right rudder but the aircraft continued to roll left. The aircraft could not be brought under control before contact with two parked…NTSB MKC86LA125Accident · No injuriesLimited investigationFinal reportCessna 150L · Nevada, IAWitnesses stated that the student appeared nervous while performing the preflight inspection for what was to be her second supervised solo flight. After engine start and initial taxi, the student began to exercise the throttle in an erratic fashion, sometimes…NTSB MIA86LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Bartow, FLThe plt stated that she landed hard on the nose wheel and the prop struck the ground, damaging the structure of the aircraft.NTSB LAX86FA240Accident · 1 fatalField investigationFinal reportCessna 177B · Fullerton, CAThe plt took off on a flt to provide traffic reports to a local broadcasting station. Witnesses rprtd that shortly aftertakeoff, the eng began to misfire. The acft entered a steep left bank angle, then plummeted toward the gnd. While still in a steep nose…NTSB FTW86LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Timbalier, LADuring the ground run portion of a water take-off from a canal, the pilot encountered a strong gust of wind to the right of the aircraft nose. The pilot lost control of the aircraft and collided with an oil rig. The pilot failed to compensate for the…NTSB FTW86LA100Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Thomas, OKShortly after takeoff at an alt of aprx 200 ft AGL, the plt attempted a snap-roll. The plt was unable to recover after the intended 1 roll and the maneuver continued for 1 1/2 rolls. The plt was able to level the wings but the acft contacted the terrain in a…NTSB DEN86LA151Accident · Minor injuriesLimited investigationFinal reportBell 206B · Portal, NDThe plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side.NTSB DEN86FA150Accident · 2 fatalField investigationFinal reportBeech A36TC · Marietta, OKThe plt obtained a wx briefing and was advised of scattered thunderstorm activity along his route of flt. The plt then filed an IFR flt plan from wiley post airport, Oklahoma city, OK, to houston intercontinental airport, TX. The plt and his wife took off at…NTSB DEN86FA149Accident · Serious injuriesField investigationFinal reportAmerican AA-1 Yankee · Cheyenne, WYDuring takeoff on a 4,997 foot long rwy, the acft became airborne, settled back onto the rwy and lifted off again just prior to reaching the end of the rwy. After takeoff the plt was not able to maintain flt. The acft impacted on a street, traveled 30 feet,…NTSB BFO86FA032Accident · Serious injuriesField investigationFinal reportBeech J-35 · Myersville, MDWhile in cruise flight at 3500 feet the pilot stated he experienced a rapid loss of power. Unable to restart the engine, he was forced to land in a pasture which was divided by barbed wire fences. The aircraft collided with a fence and came to rest inverted.…NTSB SEA86LA138Accident · No injuriesLimited investigationFinal reportRose A4C · Winnemucca, NVDuring landing roll the pilot lost directional control of the aircraft. The right main gear collapsed dragging the right wing.