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 SEA88LA072Accident · 1 fatalLimited investigationFinal reportSteen Skybolt GT-2 · Saint John, WAAfter tkof witnesses said the acft did a maneuver at 50-60 ft AGL that involved a steep (90 degree) banked turn to a snap roll. The biwing acft was capable of aerobatic flt and the plt had discussed aerobatic roll maneuvers on tkof with the acft co-owner. The…NTSB LAX88LA158Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Temecula, CAWhile on final approach, the pilot encountered crosswind conditions and was unable to maintain the runway centerline. The pilot advanced the throttle and remembered hearing the stall horn. The aircraft cleared a building by 10 feet off the side of the runway…NTSB ATL88LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Center Village, OHThe CFI attempted to demonstrate a short-field takeoff to his student, with a tailwind. He reported believing at the time that a light cross-wind/quartering tailwind was blowing. He elected to depart from rwy 27, because rwy 09 had utility wires at the…NTSB ATL88IA139Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Atlanta, GAThe left MLG outer cylinder main trunnion fractured and separated while the airplane was sitting at the gate, shortly before the planned departure. Subsequent metallurgical exam of the part revealed that it was improperly overhauled, which significantly…NTSB NYC88LA123Accident · No injuriesLimited investigationFinal reportCessna 185 · Hopedale, MAThe pilot said he flared too high and landed hard. The pilot stated that the prop contacted the ground, the right landing gear broke, and the rt wing contacted the ground and was bent rearward during the hard landing. The plt did not file an acc report.NTSB LAX88LA157Accident · Minor injuriesLimited investigationFinal reportAero Commander 560 · Bullhead City, AZNTSB LAX88LA156Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20D · Saint Helena, CAThe flight departed vacaville gliderport on an aero tow. The plt intended to fly to calistoga, CA and return. After passing st. Helena, CA, the thermal activity began to decrease. The plt executed a 180 deg turn to return to vacaville. When the flt was over…NTSB FTW88LA089Accident · No injuriesLimited investigationFinal reportCessna 172K · Houston, TXThe high-wing, tricycle gear airplane was taxiing out in winds gusting to 29 knots from about 320 degrees. While the airplane was heading 250 degrees, it was overturned to the inverted position. Owner's manual does not list any restrictions for maximum…NTSB FTW88DRA07Accident · No injuriesFinal reportGrumman G-164B · Lissie, TXAcft experienced an eng failure shortly after t/o from a pvt strip. Acft had been recently refueled at the strip. On touchdown, the acft flipped over and slid to a stop. Investigation revealed water in the acft fuel tank and in the fuel supply tank.NTSB CHI88IA097Incident · Minor injuriesIncident investigationFinal reportFairchild SA-226-TC · Bloomington, ILPhysical incapacitation due to an organic pathogen. Contributing factors are anxiety and self-induced pressure.NTSB ATL88FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bowling Green, KYPilot called fss on wrong freq. Another pilot answered & pilot req fss freq. He then called fss, rpted eng quit. Witness heard 'eng starting' momentarily overhead, watched acft pitch over, dive to gnd & impact with no attempt to flare for lnding. Pitch trim…NTSB SEA88LA071Accident · No injuriesLimited investigationFinal reportCessna 172XP · Walla Walla, WADuring descent for landing the pilot noted a surge coming from the engine area, accompanied by an increase in rpm's. both the oil temperature and the oil pressure gauges were reading zero. The cylinder head temperature had reached 500 degrees and smoke was…NTSB NYC88LA122Accident · No injuriesLimited investigationFinal reportCessna 172 · Myerstown, PAThe pilot stated that during takeoff the aircraft veered to the left and the left wheel dug into the sod. At the same time the right wing lifted up and the aircraft rolled over. The wind was variable at 10 to 15 knots, gusting to 30.NTSB MIA88FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Vero Beach, FLThe acft was observed to touch down on rwy 36 with full flaps on the grass strip bordered on both sides by citrus groves, surface winds in the area were 120 degs at 11 KTS. The acft was observed to drift to the left off the rwy toward the grove. The plt…NTSB MIA88DL001Accident · Serious injuriesFinal reportFalcon Special S/R · Lakeland, FLThe pilot experienced an in flight fire in the exhaust system while performing acrobatic maneuvers at an airshow. The aircraft is equipped with a pump that injects oil into the exhaust system to produce a visible smoke trail when vaporized by the exhaust…NTSB FTW88DPJ04Accident · 1 fatalFinal reportAerotek Pitts S-2A · Elk City, OKThe aircraft was observed doing aerobatics. A stall/spin was initiated from a climbing vertical attitude. Corrective action was not accomplished by the pilot and the aircraft was observed to spin to ground impact. No aircraft malfunctions were found.NTSB CHI88DEM04Accident · No injuriesFinal reportAnderson Pitts S-1S · Mt. Pleasant, MIThe pilot was performing some inverted maneuvers when the engine quit. The pilot stated he attempted to restart the engine but was unable to. He then executed an emergency landing in a farm field. During the landing roll the pilot was unable to maintain…NTSB ATL88DKG06Accident · No injuriesFinal reportChristen Industries Eagle II · Chamblee, GANTSB SEA88FA069Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Soda Springs, IDWhile en route on a night IFR cargo flt, the plt reqd & was clrd for a dscnt from an IFR cruise alt of 16,000 ft to proceed vfr-on-top. The last transmission from the acft was at 2106 when the plt acknowledged that he was familiar with the terrain along the…NTSB NYC88LA125Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Fairfield, PAFailure of the pilot-in-command of N34JH to see and avoid N311DP.NTSB MIA88LA145Accident · No injuriesLimited investigationFinal reportCessna 140A · Lakeland, FLWhile on a personal flt during the landing roll after the plt applied the brakes, the acft nosed over & came to rest inverted. He stated that the left brake locked up & after the acft was removed from the rwy, he disassembled each brake assy in an effort to…NTSB FTW88DRA06Accident · 1 fatalFinal reportNeff BD-4 · Beaumont, TXDuring the flight, an oil-like odor was detected and oil spots appeared on the windshield. The oil pressure dropped to zero and the engine failed. During the forced landing on a highway, the left wing struck a road sign. The spar/ fuel tank ruptured and the…NTSB DEN88LA094Accident · No injuriesLimited investigationFinal reportAgusta A109A · Sioux Falls, SDNTSB DEN88FA093Accident · 2 fatalField investigationFinal reportCessna 310I · Helena, MTThe acft depd glasgow, Montana, where the passenger (secretary of state for Montana) had been campaigning. Initially, a VFR flt plan had been filed; however, drg arrival at Helena, an IFR flt plan was filed when the plt realized the wx had deteriorated. The…NTSB ATL88FA137Accident · 2 fatalField investigationFinal reportBeech C50 · Fayetteville, NCThe pilot reported a fuel pump problem to Fayetteville tower and requested landing. The pilot was cleared to land on runway 04. The controller noticed that the pilot had not lowered the landing gear. The pilot was questioned concerning the gear. Instead of…NTSB NYC88LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · West Seneca, NYLoss of power due to fuel starvation. Contributing factor was adversed weather conditions.NTSB MKC88LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fort Smith, ARImmediately after takeoff, the student pilot performing his first supervised solo flight, said the aircraft began a left turn. He said the rudder pedals felt inoperative. He reduced power and landed adjacent the runway substantially damaging the acft.…NTSB CHI88IA096Incident · No injuriesIncident investigationFinal reportSwearingen SA-227AC · Fort Wayne, INInadequate design of the strut for the intended service conditions in commuter air carrier operations.NTSB ATL88DMG05Accident · 2 fatalFinal reportBellanca 14-19-3A · Boone, NCNTSB BFO88LA040Accident · No injuriesLimited investigationFinal reportCessna 340 · Pineville, WVThe pilot failed to maintain clearance from obstacles while taxiing the aircraft.NTSB ATL88LA135Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Briceville, TNThe plt stated that he had departed coffeyville, KS on apr 5 for an airplane delivery ferry flt to lincolnton, NC he landed at cape girardeau and remained overnight due to enroute weather. He deptd cgi the following morning following a wx brief that indicated…NTSB ATL88LA134Accident · No injuriesLimited investigationFinal reportCessna 150C · Funston, GAThe plt reported that the engine lost pwr at 200-250 ft AGL after departing rwy 30 at the private 1,750' sod airstrip. He stretched his glide to avoid wires off of the end of the rwy. After clearing the lines. The airplane nose 'fell through', and the…NTSB ATL88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe acft was taxiing for departure when a gust of wind lifted the left wing and the acft overturned. The surface winds were reported at 16 knots with gusts to 27 knots. The plt stated that proper flight control inputs were used for taxiing in windy conditions.NTSB CHI88LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Sauk Center, MNWhile enroute on the last leg of a solo cross country instructional flight, the student pilot experienced a rough running engine, followed by an engine failure. The pilot elected to land on a frozen lake, executed emergency procedures, and made a hard landing…NTSB CHI88LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Champaign, ILThe pilot had just landed at the airport for refueling and was instructed by the tower to do a 180 degree turn on the runway and then make a left turn on the first taxiway. The pilot executed the 180 degree turn and while attempting to turn left (crosswind)…NTSB BFO88FA034Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Manassas, VAThe pilot had departed waycross, GA, on the morning of the accident for a cross country flight to Manassas, VA. During the approach into Manassas, the aircraft contacted trees off the approach ends of rwys 34L and 34R. Both rwys were in use at the time and it…NTSB MKC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Springfield, MOWhile attempting to land on a narrow runway, with approaching thunderstorms within 4 miles of the airport, directional control was lost by the plt during the rollout. Plt stated a sudden change in surface wind direction made it impossible for him to maintain…NTSB MIA88LA141Accident · No injuriesLimited investigationFinal reportCessna T-188C · Miami, FLWhile taxiing from landing after a maintenance test flight, the rt main wheel assy separated from the rt landing gear strut. The acft then went off the taxiway & came to rest in the grass. Examination of the rt landing gear revealed that the spring strut…NTSB LAX88LA154Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Pine Valley, CAFailure of the number one connecting rod bearing. Contributing to this accident was the student pilot's relative inexperience and his inability to judge the glide ratio of the airplane and completing a forced landing in unsuitable terrain.NTSB DEN88LA092Accident · No injuriesLimited investigationFinal reportCessna 210L · Cheyenne, WYThe CFI was giving a checkout to the private pilot doctor. The CFI flight records showed only one hour in this make/model. The fuel selector was in the right tank position throughout the flight. The pilot reported that the engine quit on one mile short final…NTSB CHI88FA091Accident · No injuriesField investigationFinal reportBeech B90 · St. Paul, MNMechanical failure and sticking of the pilots thumb operated trim switch causing nose down pitch command. The failure of the cabin heater and the low cabin temperature are contributing factors.NTSB ANC88DAG03Accident · No injuriesFinal reportPiper PA-14 · Glennallen, AKThe pilot stated that he was flying up a fairly wide valley containing a ridge that he had to fly over. The ground was completely white with snow. The pilot noticed a hill directly in front of the aircraft; he started a turn and the aircraft struck the snow…NTSB MIA88RA139Accident · 5 fatalForeign investigationCessna 421A · Freeport, BahamasNTSB LAX88LA153Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Bakersfield, CAThe helicopter encountered weather while enroute to its dest and diverted to an alternate arpt. It overflew the alternate and, after the engine failed from fuel exhaustion, crashed during an autorotative forced landing.NTSB LAX88FA148Accident · 5 fatalField investigationFinal reportPiper PA-31-325 · Orinda, CABefore the acdnt, witnesses observed the acft circling in a valley beneath a low cloud layer & below the surrounding hilltops. They estimated the ceiling was 400' obscured. Two witnesses said the acft entered clouds before it crashed. A 3rd witness, who was a…NTSB FTW88DRA05Accident · No injuriesFinal reportHiller UH-12E · La Salle, TXAcft was substantially damaged during an emergency autorotation following an engine failure while the acft was completing an aerial application maneuver. Acft touched down tail low and the main rotor blades flexed down and cut off the tail boom. Investigation…NTSB CHI88FA092Accident · 1 fatalField investigationFinal reportCessna 207 · Hardwick, MNWitnesses observed the aircraft for aprx 8 minutes in erratic diving, climbing, and steep-turning maneuvers which culminated in a 12 degree descent to the ground. The sound of the eng was heard throughout the sequence and other evidence indicated engine power…NTSB CHI88DEM03Accident · No injuriesFinal reportGrumman G-164A · Allegan, MIThe pilot had just completed two swath runs and was turning to start the third when the aircraft began to buffet and approached a stall. The pilot then lowered the nose of the aircraft and added full throttle. After applying full throttle the pilot stated he…NTSB ATL88LA132Accident · No injuriesLimited investigationFinal reportBeech M35 · Mc Cullough, ALThe plt stated that he was landing at his destination arpt when the accident occurred. The turf/grass was wet. The acft overran the end of the rwy and collided with the terrain, several trees, and bushes. There were no mechanical malfunctions reported.NTSB MIA88LA140Accident · No injuriesLimited investigationFinal reportStart & Flug H101 Salto · Winter Haven, FLThe flt entered the downwind leg for landing when the plt observed a glider parked 600 ft from the planned touchdown point. He elected to land to the left of the glider & after turning base then final, observed individuals pushing it towards the planned…