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.

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…Apr 12, 1988 · N76JJ · DestroyedNTSB 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…Apr 12, 1988 · N5518H · Substantial damageNTSB 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…Apr 12, 1988 · N5089P · Substantial damageNTSB 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…Apr 12, 1988 · N889Z · Minor damageNTSB 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.Apr 11, 1988 · N4695E · Substantial damageNTSB LAX88LA157Accident · Minor injuriesLimited investigationFinal reportAero Commander 560 · Bullhead City, AZApr 11, 1988 · N2705B · Substantial damageNTSB 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…Apr 11, 1988 · N1NZ · Minor damageNTSB 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…Apr 11, 1988 · N7116G · Substantial damageNTSB 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.Apr 11, 1988 · N6620K · DestroyedNTSB CHI88IA097Incident · Minor injuriesIncident investigationFinal reportFairchild SA-226-TC · Bloomington, ILPhysical incapacitation due to an organic pathogen. Contributing factors are anxiety and self-induced pressure.Apr 11, 1988 · N332BA · No damageNTSB 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…Apr 11, 1988 · N32911 · DestroyedNTSB 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…Apr 10, 1988 · N736KG · Substantial damageNTSB 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.Apr 10, 1988 · N2825U · DestroyedNTSB 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…Apr 10, 1988 · N6283F · DestroyedNTSB 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…Apr 10, 1988 · N82RC · Substantial damageNTSB 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.Apr 10, 1988 · N8076 · DestroyedNTSB 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…Apr 10, 1988 · N528MS · Substantial damageNTSB ATL88DKG06Accident · No injuriesFinal reportChristen Industries Eagle II · Chamblee, GAApr 10, 1988 · N722HS · DestroyedNTSB 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…Apr 9, 1988 · N291NC · DestroyedNTSB NYC88LA125Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Fairfield, PAFailure of the pilot-in-command of N34JH to see and avoid N311DP.Apr 9, 1988 · N34JH · 2 aircraft · DestroyedNTSB 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…Apr 9, 1988 · N84SC · Substantial damageNTSB 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…Apr 9, 1988 · N1HN · DestroyedNTSB DEN88LA094Accident · No injuriesLimited investigationFinal reportAgusta A109A · Sioux Falls, SDApr 9, 1988 · N33SV · Substantial damageNTSB 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…Apr 9, 1988 · N8008M · DestroyedNTSB 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…Apr 9, 1988 · N66L · DestroyedNTSB NYC88LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · West Seneca, NYLoss of power due to fuel starvation. Contributing factor was adversed weather conditions.Apr 8, 1988 · N59845 · DestroyedNTSB 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.…Apr 8, 1988 · N31900 · Substantial damageNTSB CHI88IA096Incident · No injuriesIncident investigationFinal reportSwearingen SA-227AC · Fort Wayne, INInadequate design of the strut for the intended service conditions in commuter air carrier operations.Apr 8, 1988 · N448CA · Minor damageNTSB ATL88DMG05Accident · 2 fatalFinal reportBellanca 14-19-3A · Boone, NCApr 8, 1988 · N8880R · DestroyedNTSB BFO88LA040Accident · No injuriesLimited investigationFinal reportCessna 340 · Pineville, WVThe pilot failed to maintain clearance from obstacles while taxiing the aircraft.Apr 7, 1988 · N340FB · Substantial damageNTSB 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…Apr 7, 1988 · N46316 · DestroyedNTSB 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…Apr 7, 1988 · N7956Z · Substantial damageNTSB 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.Apr 7, 1988 · N49409 · Substantial damageNTSB 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…Apr 6, 1988 · N62218 · DestroyedNTSB 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)…Apr 6, 1988 · N64508 · Substantial damageNTSB 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…Apr 6, 1988 · N1719J · DestroyedNTSB 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…Apr 5, 1988 · N62551 · Substantial damageNTSB 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…Apr 5, 1988 · N2185J · Substantial damageNTSB 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.Apr 5, 1988 · N18136 · Substantial damageNTSB 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…Apr 5, 1988 · N910DS · Substantial damageNTSB 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.Apr 5, 1988 · N181LL · Substantial damageNTSB 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…Apr 5, 1988 · N5188H · Substantial damageNTSB MIA88RA139Accident · 5 fatalForeign investigationCessna 421A · Freeport, BahamasApr 4, 1988 · N42ANTSB 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.Apr 4, 1988 · N646JS · Substantial damageNTSB 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…Apr 4, 1988 · N6ET · DestroyedNTSB 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…Apr 4, 1988 · N4029D · Substantial damageNTSB 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…Apr 4, 1988 · N207CA · DestroyedNTSB 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…Apr 4, 1988 · N84PG · Substantial damageNTSB 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.Apr 4, 1988 · N2255K · Substantial damageNTSB 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…Apr 3, 1988 · N999WC · Substantial damage