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 ATL88DLQ01Accident · No injuriesFinal reportByron/Sorrell SNS-2 · Morehead, KYInflight separation of both propeller blades from the acft for undetermined reasons.Jun 8, 1988 · N112CB · Substantial damageNTSB NYC88FA158Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Enon Valley, PAThe aircraft was observed maneuvering at low altitude. The nose was observed to drop and a left rotation started. One witness said the rotation stopped before the aircraft disappeared behind a tree line. The aircraft caught fire within one minute of impact…Jun 7, 1988 · N2317N · DestroyedNTSB MKC88LA107Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Hazen, ARWhile performing an aerial application operation at dawn, the plt struck a levee. He attributed the acdt to low light intensity, a dirty windscreen and encountering his own wake turbulence. The main gear was sheared off, then the aircraft nosed down, slid for…Jun 7, 1988 · N8027K · Substantial damageNTSB LAX88LA216Accident · No injuriesLimited investigationFinal reportCessna 150M · Ramona, CADuring the climb to cruise phase of the flt, the engine experienced a loss of power. The pilot applied carburetor heat and the power began to return. Due to the loss in altitude, the plt opted to make a forced landing in a field where just prior to touchdown,…Jun 7, 1988 · N66167 · Substantial damageNTSB LAX88LA208Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Corona, CACompany maintenance personnel had replaced the nose landing gear assy and had conducted retraction tests prior to releasing the acft for flt. After takeoff the lndg gear was retracted and the flt was conducted without incident until, upon entering the traffic…Jun 7, 1988 · N2710M · Substantial damageNTSB FTW88FA115Accident · 2 fatalField investigationFinal reportCessna 340 · Georgetown, TXThe pilot in the right seat had hired the pilot in the left seat to ferry the airplane to germany, then to turkey. A four tank ferry fuel system was installed but a weight and balance check was not made. During the tkof, the acft would not climb. Afterward…Jun 7, 1988 · N7828Q · DestroyedNTSB FTW88DRD07Accident · Minor injuriesFinal reportPezetel M-18 · Mer Rouge, LAThe ag airplane departed the strip with 3000 lbs of fertilizer. 200 yds later it settled in a rice field and flipped forward to the inverted. No mechanical problems were found. Elevation at takeoff was 150 ft MSL. Density altitude was 2272 ft. max allowable…Jun 7, 1988 · N4685R · Substantial damageNTSB DEN88DTE05Accident · No injuriesFinal reportPiper PA-25-235 · Limon, COThe plt reported that he was making his third swathrun when the eng quit. He attempted a forced landing but the acft nosed over. The plt said he had 15 gal of fuel on board at takeoff and had been airborne about 15 min. The FAA a/w insp who examined the…Jun 7, 1988 · N8678L · Substantial damageNTSB BFO88IA057Incident · 1 fatalIncident investigationFinal reportPiper PA-31 · Morgantown, WVThe pilot died from coronary disease while practicing landings.Jun 7, 1988 · N811CM · No damageNTSB ATL88LA190Accident · Minor injuriesLimited investigationFinal reportSikorsky S-55C · Coaling, ALThe helo was approaching a helipad for landing after the last aerial application flight of the day when there was a pop and tail rotor control was lost. After several rotations about the vertical axis, the PIC landed the helo hard, collapsing the landing…Jun 7, 1988 · N883 · Substantial damageNTSB MKC88LA108Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Wynne, ARFollowing the takeoff from a private strip near Wynne, Arkansas, the pilot reported that he failed to establish and maintain an adequate angle of climb with the heavily loaded condition of the aircraft. The aircraft impacted trees in the flight path, then…Jun 6, 1988 · N9695 · Substantial damageNTSB LAX88LA214Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Bakersfield, CAWhile on an instructional flt, the CFI instructed the student to fly above the power line poles at all times. While in cruise flight the instructor was looking away when the helicopter collided with power lines. The instructor took control of the helicopter…Jun 6, 1988 · N2634N · Substantial damageNTSB FTW88FA114Accident · Minor injuriesField investigationFinal reportCessna 172P · Houston, TXMooney N231QB was involved in a midair collision with Cessna N96957 while both aircraft were landing at the uncontrolled west Houston-lakeside airport. The Mooney aircraft was returning on a straight-in approach. The pilots of the Cessna aircraft were in the…Jun 6, 1988 · N96957 · 2 aircraft · DestroyedNTSB FTW88DRA14Accident · No injuriesFinal reportGrumman G-164B · College Port, TXAcft was substantially damaged when it executed an off-arpt landing following takeoff FR0M a wet sod strip on an ag flt. The plt stated that he was taking off to the north and that during the t/o roll the wind shifted to out of the south. He further stated…Jun 6, 1988 · N6615Q · Substantial damageNTSB FTW88DPJ05Accident · 1 fatalFinal reportStinson 108-3 · Collinsville, OKThe pilot experienced a loss of engine power during the takeoff leg. Post accident investigation revealed that the fuel selector was in the near closed position. This position only allowed a small percentage of the fuel to flow but would allow operation in…Jun 6, 1988 · N4108C · DestroyedNTSB BFO88LA053Accident · No injuriesLimited investigationFinal reportCessna 172P · Gaithersburg, MDAccording to the plt, after touchdown the acft encountered a crosswind gust. The acft drifted left of the rwy where it collided with trees. The plt reported no mechanical malfunction.Jun 6, 1988 · N65720 · Substantial damageNTSB SEA88LA104Accident · No injuriesLimited investigationFinal reportCessna 210 · Reno, NVDuring an instructional flight and an ILS approach, a total loss of engine power occurred at about 1200 feet AGL. A forced landing was made onto rough terrain. During landing roll the nose gear separated from the aircraft. The private pilot receiving…Jun 5, 1988 · N70SA · Substantial damageNTSB NYC88LA161Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Franconia, NHDuring takeoff, turbulence was encountered and the student pilot had a hard time controlling the glider. As the instructor took control, the student released the tow rope. The instructor pushed the nose down and turned in an attempt to level the wings, but…Jun 5, 1988 · N49443 · Substantial damageNTSB NYC88LA160Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Westerly, RIThe instructor pilot stated that after executing several straight-in and 180 degree autorotations they decided to attempt some hovering autorotations. After executing the first one successfully in a tailwind situation, the student initiated the second one,…Jun 5, 1988 · N580H · Substantial damageNTSB NYC88LA159Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33 · Erwinna, PAAccident was a loss of directional control during landing which followed a hard landing. Contributing was the improper use of spoiler control by the private pilot and the failure of the flight instructor to adequately supervise the actions of the private…Jun 5, 1988 · N1240S · Substantial damageNTSB MKC88LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Dewitt, ARThe pilot was attempting to land on his personal grass strip, which had trees at both ends. The acft hit hard, bounced, then slid to a stop. The nose gear was separated.Jun 5, 1988 · N97536 · Substantial damageNTSB MKC88DCD01Accident · No injuriesFinal reportBohnker Tierra II · Audubon, IAThe pilot stated that the takeoff run and liftoff appeared normal, but after liftoff the aircraft veered to the right (into the crosswind). The pilot attempted to correct with left rudder and aileron. When he was unsuccessful, he retarded throttle. The plane…Jun 5, 1988 · N116LB · Substantial damageNTSB LAX88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grand Canyon, AZFailure of the an tee fitting, thereby allowing the oil to be pumped overboard causing the engine failure. The failure of the tee fitting was caused by the tie wrap used to secure the line. The tie wrap pulled the oil line and stressed one side of the tee…Jun 5, 1988 · N2131N · Substantial damageNTSB LAX88DVM02Accident · Minor injuriesFinal reportBell 47G5 · Oceano, CAJun 5, 1988 · N1316X · Substantial damageNTSB LAX88DVD04Accident · 1 fatalFinal reportBellanca 8KCAB · Geyserville, CADuring an aerobatic maneuver in front of family and friends the pilot entered an intentional spin starting at approximately 500 ft AGL. The aircraft collided with the ground in a nose low, wings level attitude. Witnesses stated that the aircraft did not…Jun 5, 1988 · N5061W · DestroyedNTSB DEN88LA123Accident · Serious injuriesLimited investigationFinal reportHelio H-295 · Encampment, WYThe plt stated he calculated the density altitude to have been 11,300 ft at takeoff. He said the acft was near max gross wt and that the grass strip he departed from was approx 1,500 ft long. The plt stated 'I was on the on the back side of the pwr curve as…Jun 5, 1988 · N6454V · DestroyedNTSB DEN88LA122Accident · No injuriesLimited investigationFinal reportBeech C23 · Gallup, NMThe private plt was taking off with three passengers for a personal transportation flight. The airplane left the runway and only gained about 50 feet AGL according to a witness. The plt reported that the aircraft reached 200 feet AGL. The airplane stalled and…Jun 5, 1988 · N9311S · Substantial damageNTSB CHI88LA127Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L-2 · Three Rivers, MIThe owner of the acft stated that he released the acft to the PIC so that he could 'checkout' another plt and help her with her tailwheel landings. During their fourth tkof, the plt being checked out attempted to climb out of ground effect with insufficient…Jun 5, 1988 · N57502 · Substantial damageNTSB CHI88LA125Accident · Minor injuriesLimited investigationFinal reportCessna TU206B · Ellsworth, WIDuring cruise flight the pilot experienced an engine failure which he believed to be caused by fuel exhaustion, and executed a forced landing in unsuitable terrain. Post accident inspection revealed that the left fuel tank contained 23 gallons of fuel at the…Jun 5, 1988 · N4757F · Substantial damageNTSB CHI88FA128Accident · No injuriesField investigationFinal reportDornier 228-201 · Chicago, ILThe capt was completing the checklist drg pax loading & the f/o secured the door & came fwd. The capt started the #2 eng& bgn single eng taxi while atmtg a rgt turn to stay clr of a parked Dornier (N264MC). As N259MC bgn rolling fwd, the capt noted the…Jun 5, 1988 · N259MC · Substantial damageNTSB SEA88LA105Accident · No injuriesLimited investigationFinal reportCessna 175 · Olympia, WAAfter reducing power in order to land onto the runway a total loss of power occurred. The aircraft was landed short of the ruwnay and during landing roll a ditch was struck collapsing the right main and nose gear. Aircraft inspection revealed 2 2/3 gallons of…Jun 4, 1988 · N90134 · Substantial damageNTSB MKC88LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lakeview, ARWhile attempting to land crosswind on a 'one way' runway, the plt said a gust of wind blew him towards some bordering trees, so he made a decision to 'go around'. The plt said he applied full throttle and raised the flaps from the full flap setting, and…Jun 4, 1988 · N75540 · Substantial damageNTSB MKC88LA105Accident · No injuriesLimited investigationFinal reportBeech 35C · Manhattan, KSArriving at the original destination apt, the PIC decided on an alternate, nearby airport, due to confusion regarding runway conditions at the original destination apt. Flying to his alternate, he erroneously lined up at a military airport located about 10…Jun 4, 1988 · N5878C · Substantial damageNTSB LAX88LA212Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Lihue, HIFatigue failure of the engine to transmission drive shaft engine coupling due to an angular misalignment of the drive shaft.Jun 4, 1988 · N53EP · Substantial damageNTSB LAX88LA211Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Lakeport, CADuring a banner tow operation, the plt tried to release the banner. When the banner did not disconnect, the plt turned to see what the problem was. The airplane stalled and before the plt could regain control, it collided with the terrain. Inspection of the…Jun 4, 1988 · N9124C · Substantial damageNTSB LAX88LA210Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Hemet, CADuring the landing while on a solo (instructional) night cross country flight, the airplane touched down, bounced, and veered left. During the second bounce between the runway and the taxiway, the pilot added power. The airplane continued in a straight path…Jun 4, 1988 · N6181L · Substantial damageNTSB FTW88DRD08Accident · Minor injuriesFinal reportCessna T-210N · Ruston, LADuring climbout, the engine lost power and the airplane made a forced landing in a wooded area. After hitting trees and the terrain, the airplane burned. No pre-impact problems were found with the powerplant. Vented fuel caps had been installed but were…Jun 4, 1988 · N6449Y · DestroyedNTSB DEN88LA124Accident · No injuriesLimited investigationFinal reportCessna A-185F · Phillipsburg, MTJun 4, 1988 · N94237 · Substantial damageNTSB DEN88FA121Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rock Springs, WYShortly after departure on the second leg of a cross country flt the plt informed the fss located on the arpt that he was returning. The fss technician on duty observed the acft turn final at an abnormally low altitude. The acft disappeared from view. The…Jun 4, 1988 · N9728J · DestroyedNTSB DEN88DTK01Accident · Serious injuriesFinal reportEagle DW-1 · Ferney, SDThe ag plt reported that he encountered a 'dust devil' while in a climbing turn during a turnaround at the end of a swath run. He said he attempted to counter the turbulence enduced roll with appropriate flt control inputs but the acft did not recover and…Jun 4, 1988 · N8802Z · DestroyedNTSB CHI88LA126Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aledo, ILDuring takeoff roll the pilot reported he experienced a loss of directional control and elected to lift the aircraft off the ground prematurely in an effort to avoid running into a cornfield. Unable to establish the proper rate of climb, and unable to clear…Jun 4, 1988 · N95061 · DestroyedNTSB ATL88LA188Accident · No injuriesLimited investigationFinal reportMooney M-20 · Hartwell, GAThe nose gear collapsed while taxiing at a speed of about 5 mph after landing. The annual inspection failed to disclose a material problem with the gear truss. Examination of the fractured component disclosed that the tubular material had rusted from the…Jun 4, 1988 · N5705Q · Substantial damageNTSB SEA88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Hawthorne, NVDuring a go-around due to the pilot having difficulty landing with a gusting crosswind, the aircraft struck a barbed wire fence with the main landing gear and a fence post with the left horizontal stabilizer. The aircraft then crossed a road and came to rest…Jun 3, 1988 · N3741P · Substantial damageNTSB MKC88DCQ03Accident · Serious injuriesFinal reportAeronca 11AC · Ada, KSThe a/c contacted powerlines about 25 feet AGL, contacted a tree, broke another powerline, and then crashed into a pickup truck. No evidence of preimpact mechanical problems were found with either airframe or powerplant. A toxicological test of the pilot…Jun 3, 1988 · N85985 · Substantial damageNTSB MIA88FA187Accident · Serious injuriesField investigationFinal reportCessna 172N · Jacksonville, FLThe private pilot had been hired to ferry a recently purchased aircraft. He stated that the aircraft had not been flown for about 2 weeks. He had it refueled and checked the fuel tanks for water. After takeoff the engine failed at about 200 ft. he crashed…Jun 3, 1988 · N5245E · Substantial damageNTSB LAX88LA209Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Vacaville, CAAt the end of a pleasure flt, the plt extended the downwind leg for landing, thinking that the touchdown altitude was 12 ft instead of, in actuality, 220 ft. the plt normally flew out of another airport with an alt of 12 ft. from the extended downwind, the…Jun 3, 1988 · N7768S · Substantial damageNTSB DEN88FA120Accident · 1 fatalField investigationFinal reportLuscombe 8E · Grantsville, UTThe acft was 1 of 3 that were lndd on a gravel road near a truck stop where the occupants had breakfast. Drg departure, the 1st 2 acft took off without incident. Witnesses rprtd that when the 3rd acft (N71646) took off, the plt began a left turn at about 75'…Jun 3, 1988 · N71646 · DestroyedNTSB CHI88IA129Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Madison, WIFailure of the right outboard flap position signalling cable due to chaffing initiated by improper installation/rigging by a manufacturer's vendor.Jun 3, 1988 · N383MQ · No damageNTSB NYC88LA153Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Latrobe, PAAccident was pilot loss of directional control during landing.Jun 2, 1988 · N90DR · Substantial damageNTSB DEN88LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Gettysburg, SDThe commercial plt and two passengers were flying to a fishing camp. During landing roll the plt applied brakes to turn off the runway. The nose got too FAR around and directional control was lost. The airplane ground looped to the left. The right wing, right…Jun 2, 1988 · N2123Z · Substantial damage