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 NYC84FA184Accident · 1 fatalField investigationFinal reportCessna T210M · Bloomsburg, PAThe acft collided with pwr lines during an attempted go-around. Witnesses stated the acft was nose low until just prior to touchdown when it pitched up. The acft bounced into the air and touched down on the nose gear. The acft 'rocked side to side' on the rwy…NTSB MIA84IA172Incident · No injuriesIncident investigationFinal reportBoeing 727-35 · Bahamas, BahamasWhile climbing thru FL 240, the aircrew noted that the #1 eng fire warning light illuminated. They secured the eng in accordance with the eng fire checklist procedure, then diverted for an unscheduled landing at miami, FL. An investigation revealed that the…NTSB FTW84LA241Accident · No injuriesLimited investigationFinal reportCessna 172P · Stillwater, OKPlt stated the acft nose raised up before takeoff speed had been reached. Control of the acft was lost and it descended into a field aprx 500 ft off the end of the rwy in an area of unimproved terrain. Plt later reported the elevator trim was set in the full…NTSB DEN84LA158Accident · No injuriesLimited investigationFinal reportPitts S-2A · Boulder, COThe acft was observed in a high, power-on apch. According to a professional plt, who was a witness, the acft appeared asif it would land long. He reported that power was reduced at about 50 ft AGL & the acft stalled, then it landed hard, bounced high &…NTSB DEN84LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bountiful, UTThe aircraft was on short final during instructional landing practice. A truck loaded with a backhoe was crossing the end of the runway from left to right on a public access road which displayed no caution or warning signs regarding aircraft operations.…NTSB DEN84IA157Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Albuquerque, NMWhen gear was lowered for landing rt main gear would not extend although persons on the ground stated the gear doors appeared open. Remedial action by the flt crew did not rectify the situation and a gear up landing was performed. When acft was raised from…NTSB CHI84LA205Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Pontic, MIThe plt stated that during the flare in a cross-wind landing, the acft ballooned & drifted to the right. The acft then touched down at an angle & the landing gear collapsed. The wind was gusting to 20 KTS.NTSB CHI84FA201Accident · Minor injuriesField investigationFinal reportCessna 310P · West Chicago, ILThe plt heard a loud noise during gear retraction and noted that the nose gear could not be extended. Attempts to correct the situation failed. On the approach to land he put the mixture controls in idle cut off to slow the acft. The acft stalled and landed…NTSB ATL84FA183Accident · Serious injuriesField investigationFinal reportCessna 152 · Piedmont, ALThe plt reported that prior to flying, he had 2 mixed drinks which contained alcoholic beverage. The flt originated at talledega, AL. The plt then flew to anniston, AL, where he landed. From there he flew to jacksonville & centre, where he made touch-&-go…NTSB ANC84LA076Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Nunavachak, AKThe plt of a Piper PA-32, N4143W, was taking off toward the west-northwest on a tidal beach at the same time that another plt was taxiing west onto the beach. The other plt was taxiing a high wing, Bellanca 7GCBC, N2677Z. The Bellanca was angling down onto…NTSB ANC84FA075Accident · No injuriesField investigationFinal reportPiper PA-12 · Palmer, AKThe acft landed fast & long on the rough 1300 ft grass & dirt rwy. At the departure end of the strip, the the acft nosed over as the plt was applying braking action.NTSB NYC84LA183Accident · No injuriesLimited investigationFinal reportBeech A23 · Matawan, NJLanding long at night to avoid unseen obstructions, the pilot misjudged his touchdown point and ran off the end of the rwy, colliding with brushy vegitation.NTSB MKC84LA145Accident · No injuriesLimited investigationFinal reportPietenpol-Grega GN1 · Warrensburg, MODuring a landing, the acft ran off the side of the rwy, hit a small ditch & nosed over.NTSB MKC84LA144Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Louisville, NEAccording to the plt, the helicopter was involved in a ground search with a non-trained pax in the right seat. With the pax flying the acft in a hover the right skid contacted the muddy terrain causing the acft to roll over.NTSB MKC84LA143Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Silver Creek, NEThe plt stated he was making an end pass while spraying a pasture & collided with a hilltop on the opposite side of a draw. This occurred while the sun was obstructing his vision.NTSB MIA84LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Opa Locka, FLThe plt was practicing touch-&-go landings. After touching down on the 2nd landing, he saw a patrol vehicle crossing the rwy. The plt deviated to the left to avoid the vehicle, then he elected to go around. However, he then realized that there was…NTSB MIA84FA170Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · St.Petersburg, FLAccording to witnesses, the plt did at least one complete roll prior to the accident. They stated that after rolling at about 100 ft above the water & parallel to the beach, the acft appeared to bank very steeply to the left, then pitch down into the water.…NTSB LAX84LA311Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Williams, CAShortly after departing the airfield, the eng lost power & the plt was unable to restart it. He landed in a soft, freshly plowed field. After rolling about 50 ft, the acft nosed over. An exam revealed that the shaft which holds the float assembly in the…NTSB FTW84LA239Accident · No injuriesLimited investigationFinal reportCessna 172 · San Antonio, TXThe acft ran off the departure end of the rwy during landing, went through a fence on into a street. Tower personnel said the acft landed faster then normal about 1/2 way down the rwy and bounced several times before going through the fence. The plt said he…NTSB DEN84LA154Accident · No injuriesLimited investigationFinal reportCessna 150L · Evanston, WYPlt stated he couldn't make radio contact with the arpt and the wind sock indicated a x-wind so he elected to use rwy 34. The acft bounced during the landing. Plt stated, 'the wind shifted from a x-wind to 140 deg, causing a downwind which caused the plane to…NTSB DEN84FA159Accident · Serious injuriesField investigationFinal reportGrumman American AA-1C · Rapid City, SDThe acft collided with rolling terrain while on a dual training flt. The CFI stated that the student plt was in the process of doing a simulated engine out forced landing when he raised the nose too high. The CFI and student were discussing the terrain when…NTSB NYC84LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Marlboro, NJThe pilot aborted his takeoff when he noted insufficient acceleration, but lost control of the aircraft, ran off the end of the runwaym thru a ditch and onto railroad tracks.NTSB NYC84LA181Accident · No injuriesLimited investigationFinal reportCessna 177B · Spring Valley, NYSufficient alt was not obtained to clear trees located aprx 100 ft off the departure end of the rwy during an aborted landing to avoid an overrun.NTSB NYC84FGT01Accident · Serious injuriesFinal reportMooney M20C · Slate Run, PAThe acft crashed shortly after takeoff from the black forestairport. Investigation revealed that the acft traveled approx 2/3RDS of the rwy distance, became airborne, settled back on the rwy & became airborne again. At the time of takeoff the acft was loaded…NTSB NYC84FA180Accident · 1 fatalField investigationFinal reportBeech D-45 · Taunton, MAN812Z crashed in a wooded area about one mile southeast of the Taunton municipal airport. Witnesses in the area observed the acft prior to the crash. One witness saw what appeared to be yellow smoke coming from the bottom of the acft. Some of the witnesses…NTSB MIA84FA169Accident · 1 fatalField investigationFinal reportCessna 152 · Atlantic Ocean (Atlantic Ocean)The student was on the 3rd leg of a solo, x-country flt. On the 2nd leg, he asked for a df steer to reach the arpt. During lunch, he discussed the situation with his instructor, who was at the arpt with another student. The solo student departed at 1455 EDT,…NTSB LAX84LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Ballard, CAThe pilot of N73857, a Cessna 172 and the pilot of N521ST, a Cessna 305 arranged prior to the flight to fly a 'missing man' formation with two other aircraft. The plt of N73857 was instructed to fly to the left rear of the lead acft, N521ST. The pilot of…NTSB DEN84LA160Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Englewood, COAccording to the plt, the acft touched down during a landing, then became airborne again in unfavorable wind conditions. He reported that the plane then slammed back onto the rwy & was damaged.NTSB ATL84LA182Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Jacksonville, ALAccording to the instructor (CFI), he & the student were practicing base-to-final turns as they were returning to the arpt. He reported that the acft was flown at about 60 KTS with 20 deg of flaps at appx 800 ft AGL. He stated that the student steepened the…NTSB ANC84FA074Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKAccording to witnesses, the plt made 3 low passes at some boats in Sleetmute slough. They estimated the passes were at 5 to 10 ft above the water, then the plt would pull up in a steep climb attitude, execute a 180 deg turn and make another pass. After the…NTSB SEA84LA114Accident · No injuriesLimited investigationFinal reportMorrisey 2150 · Enumclaw, WAThe plt was on a local test flt to check the flt controls that had just been adjusted. Before taking off, he visually inspected the fuel tanks, but could not see fuel since anything less than 1/2 tank was not visible. He said the fuel gages indicated both…NTSB NYC84LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chatham, MADirectional control was lost during the takeoff ground roll with a slight quartering tailwind. Power was reduced but the acft traveled off the left side of the rwy where it collided with a tree.NTSB NYC84FA178Accident · 1 fatalField investigationFinal reportCessna 210E · Glen Burnie, MDBefore the flt, the plt was observed performing maintenance in the eng compartment. He was known to do some of his own maintenance which included stopping an oil gasket leak by using a sealer. While climbing after takeoff, he turned back to the departure…NTSB MKC84LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · North Platte, NEWhile in cruise flt the plt noticed a loss of electrical power. A diversion was made to North Platte, NE, where the plt hoped to have the electrical problem fixed. Numerous attempts were made to lower the landing gear but to no avail and a gear up landing…NTSB LAX84LA312Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAThe acft landed hard and porpoised down the rwy. The plt made a go-around and reported to the tower that he had control problems. He performed a tower fly-by and no damage was apparent to the controllers. The plt was cleared for landing anddid so without…NTSB ANC84FA073Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Platinum, AKThe herring season was to open at 1600 hrs. According to witnesses, about 30 acft were circling in left turns over merging schools of herring while the plts & their respective boat crews were awaiting the opening signal. The acft were circling under a low…NTSB ANC84FA072Accident · No injuriesField investigationFinal reportPiper PA-28-235 · Egegik, AKThe acft crashed during a forced landing on unsuitable terrain. The plt said the acft engine lost oil-pressure about 20 minutes after takeoff and he turned toward the closest arpt. The engine operated a few minutes and then stopped. The acft was landed off…NTSB SEA84FA111Accident · 4 fatalField investigationFinal reportStinson 108-3 · Portland, ORThe plt was briefed on the weather along his intended route of flt & VFR flt was not recommended. The acft departed vancouver, WA, and flew to tigard, OR. It was observed to depart tigard at about 1810 PDT. Numerous witnesses reported that at about 1815, they…NTSB NYC84LA179Accident · No injuriesLimited investigationFinal reportCessna 175 · Ticonderoga, NYA student plt performing touch and go landings observed another acft at the departure end of the rwy, facing him. Assuming a collision was immenent, the plt aborted the takeoff, but locked the brakes while trying to stop. The acft swerved off the rwy, the…NTSB NYC84FHD02Accident · 1 fatalFinal reportCessna 337 · Coatsville, PAAfter touchdown about 2,000 ft down the 4,600 x 100 ft rwy the acft bounced back into the air. Witnesses observed the acft rt wing drop causing it to veer to the rt toward a line of parked acft. 900 ft from initial touchdown the acft impacted rt wing first in…NTSB NYC84FA202Accident · Serious injuriesField investigationFinal reportBell 206B · Georgetown, DEAfter performing police patrol activities, the aircrew landed, refueled the helicopter, then took off to practice autorotative landings. Two autorotative landings were made on rwy 22, then 2 more were made on an adjacent grass area. After the 2nd landing on…NTSB LAX84LA306Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · San Jose, CAThe acft nose gear collapsed during landing. Witnesses described the bounced landing as a 'porpoise'.NTSB LAX84LA305Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Waipahu,Oahu, HIThe CFI gave the student a simulated forced landing and the student spiraled down to 400 ft AGL. When the CFI said 'i'vegot the airplane' the acft nose came up and the acft started to settle. The CFI stated he applied power but the acft continued to settle,…NTSB LAX84LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Avalon, CAThe plt flew to catalina island, then flew northwest along the north side of the island. He stated that he then made a climbing left turn over the island from about 500 ft MSL, but encountered a downdraft at 1000 ft MSL, which slowed the acft below the…NTSB LAX84LA302Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5B · Ruth, CAWhile attempting to land on rwy 31, the plt elected to go-around. He made a low pass down the rwy, pulled up at the end of the rwy for a downwind entry & began to mush. The acft hit a tall tree & impacted the ground.NTSB LAX84LA301Accident · Minor injuriesLimited investigationFinal reportGrumman F-6F5 · Chino, CAThe plt stated that he made a normal landing, but 'upon touching brakes, left brake appeared to lock.' He stated he was unable to correct with right rudder & brake. The acft swerved off the left side of the rwy, went into a ditch & nosed over. Witnesses…NTSB LAX84FA304Accident · 1 fatalField investigationFinal reportBrubaker Q-2 · Corona, CAThe plt of a quickie Q-2 had returned to the arpt & made 2 low passes, then began a normal apch to rwy 25. When the Q-2 was on a low final, the plt of a Mooney acft turned onto the rwy & began taking off. At about that time, a ground witness heard the…NTSB FTW84LA238Accident · No injuriesLimited investigationFinal reportCessna 150H · Sunray, TXDuring initial climb, at an altitude of 8 to 10 ft AGL, the student plt reported experiencing 'turbulence like a down draft' & the acft settled back to the rwy. Believing that insufficient rwy remained to clear approaching power lines, the plt intentionally…NTSB FTW84FA237Accident · 1 fatalField investigationFinal reportBeech G35 · Tulsa, OKA witness stated it appeared as though the plt was attempting to perform a precautionary landing on a highway. As the acft reached the highway, the witness heard the engine accelerate to 'full power' and saw the acft pull up. The acft contacted the top static…NTSB DEN84FU005Accident · 1 fatalFinal reportEipper Quicksilver MX · Peyton, COThe ultralight was flying in formation with 2 other craft. The accident plt was seen by one of the other two plts to descend to a low alt over a creek bed and then pull up abrultly to climb over a power line. The landing gear collided with the wires and the…