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 MKC87DPG02Accident · Serious injuriesFinal reportPiper PA-25-235 · Hazen, ARThe pilot stated to a witness that after coming out of his 2nd pass, in the last 1/3 of his procedural turn, the plane stalled and the right wing struck a telephone wire which caused it to swing onto a gravel road. It hit left wing/nose down, bounced, and…Jul 11, 1987 · N7705Z · DestroyedNTSB MIA87IA204Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Washington, DCDrg arr, the acft's radar showed tstms in the area of the arpt. As the flt contd, ATIS info chgd. When the plts ctcd Washington apch ctl with old ATIS info, the ctlr did not correct the flt. They were adzd of hvy rain, strong wnds & a PIREP of wndshr nr the…Jul 11, 1987 · N8892Z · Minor damageNTSB LAX87LA270Accident · No injuriesLimited investigationFinal reportCessna 172P · Grass Valley, CADuring a pleasure flight, while attempting to land at the airport, the pilot made a go around because he was too high. On the second approach, the pilot noted that he may have been a little high and fast. During the landing the aircraft bounced three times…Jul 11, 1987 · N5259K · Substantial damageNTSB LAX87LA265Accident · No injuriesLimited investigationFinal reportBeech D18S · Riverside, CAThe acft had not been flown for svrl years & was on a flt to ferry it to another location. While cruising at 7500', the plt decided to start using aux fuel. Shortly after moving the fuel selectors to the aux psn, both engs lost power & would not restart. The…Jul 11, 1987 · N99CP · Substantial damageNTSB FTW87DRA06Accident · No injuriesFinal reportGrumman G-164B · Beaumont, TXDrg the initial climb after takeoff, the eng began losing RPM & the plt was unable to return to the arpt. He selected a pasture area for an emerg landing, but the eng contd losing power. While landing on soft terrain with tall wet grass, the acft nosed over.…Jul 11, 1987 · N6881K · Substantial damageNTSB DEN87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Kalispell, MTThe pvt plt was on a x-country flight. The engine began running rough, made a 'bang' sound and lost partial power. Smoke entered the cockpit, oil pressure was lost and the plt initiated an emergency landing. The acft ldg gr struck powerlines on approach to a…Jul 11, 1987 · N9201B · Substantial damageNTSB DEN87FA178Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Hayden, COThe plt and two pax were participating in the denver, CO to jackpot, NV air classic. The acft departed, destined for rock springs, WY. The plt was believed by a friend to have been navigating with the use of a recently installed RNAV system. The plt radioed a…Jul 11, 1987 · N7858P · DestroyedNTSB ATL87DLT03Accident · 1 fatalFinal reportBurkhart Grob G102-111B · Memphis, TNGlider tow rope released at about 200FT following t/o. glider made rt turn followed by stall/spiral which continued until ground impact. Tow pilot saw glider pilot's hat falling to ground just after tow rope was released by glider pilot. Glider canopy was…Jul 11, 1987 · N3950L · DestroyedNTSB ATL87DEI09Accident · No injuriesFinal reportCessna 170B · Upper Sandusky, OHDuring takeoff attempt from runway 36 the aircraft veered to the left about 250 feet from the runway threshold and contacted the ground. The pilot reported that a crosswind caught him off guard. Weather information obtained from findlay flight service…Jul 11, 1987 · N3142A · Substantial damageNTSB ANC87LA094Accident · No injuriesLimited investigationFinal reportCessna 185 · Aleknagik, AKThe commercial pilot and his three passengers were on a fishing trip to a remote stream in southwest Alaska. The pilot attempted to land on a beach area near the stream and nosed the airplane over. The airplane was equipped with large 'tundra' tires that the…Jul 11, 1987 · N5430R · Substantial damageNTSB ANC87LA093Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Dillingham, AKThe student pilot stated that the aircraft lost partial power during the take off run due to water being ingested into the engine air filter as he made his water takeoff. He elected to continue with the takeoff attempt and struck the shoreline prior to…Jul 11, 1987 · N1304H · Substantial damageNTSB MKC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldron, ARThe plt said he was on a x-country for his commerical cert. He checked enroute wx for the return trip and was told VMC prevailed. However he rptd that he encountered haze & clouds. He let down to VMC but after he got in the clear all he could see was…Jul 10, 1987 · N5921U · Substantial damageNTSB MKC87LA134Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Benton, ARDuring a positioning flt to pick up revenue passengers, PIC neglected to lower ldg gear for ldg. Acft was substantially damaged. PIC stated he forgot to lower gear and no warning horn had activated.Jul 10, 1987 · N4JD · Substantial damageNTSB MKC87LA132Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Russellville, ARDuring the night approach, the pilot saw the reflection of orange balls on a powerline. He added power and went over the powerline, then reduced power to land and stalled the aircraft short of the runway. The nose gear broke off and the airplane slid 200…Jul 10, 1987 · N3604Q · DestroyedNTSB MIA87FA203Accident · Serious injuriesField investigationFinal reportRockwell 112A · Vero Beach, FLAfter take-off, the rt wing of the acft hit the ground about 1500 ft down the north-south rwy. The plt stated that the acft was rt wing heavy and opposite aileron had no effect. Surface winds at Vero Beach, about 8 miles east of the accident site were 090…Jul 10, 1987 · N1440J · DestroyedNTSB LAX87LA263Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Keams Canyon, AZDuring a business flight to a private dirt strip, while on final approach the plt was distracted for a few seconds. When his attention was back on the acft, it had drifted east of the strip. The plt applied pwr, however, he stated that the engine did not…Jul 10, 1987 · N3598U · Substantial damageNTSB FTW87LA169Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Houston, TXThe instructor plt (CFI) stated that drg the preflt, he & the student drained about 1 pint of water from the left wing tank & a small amount from the lower eng sump drain. No water was found in the rgt tank. The left tank was selected & a 12 to 15 min eng…Jul 10, 1987 · N40684 · Substantial damageNTSB FTW87DRA05Accident · No injuriesFinal reportCessna A188B · El Campo, TXWhile attempting to land, the aircraft's left wing contacted the edge of a corn field. The aircraft veered to the left and impacted the ground causing substantial damage.Jul 10, 1987 · N731LP · Substantial damageNTSB CHI87DER12Accident · No injuriesFinal reportTaylorcraft F21A · Int'L Falls, MNWhile on initial climb the aircraft encountered downdrafts and was unable to climb over high terrain and trees. When it became obvious to the pilot that he was not going to be able to climb over these obstacles, he closed the throttle and attempted to turn…Jul 10, 1987 · N2006L · Substantial damageNTSB CHI87DER09Accident · 1 fatalFinal reportGreat Lakes Adams 2T-1 · Bethel/Msp, MNThe amateur built aircraft impacted in an open farm field. Although witnesses did not agree on the altitude the aircraft was flying at, they all stated that the Great lakes 2T-1 was spinning before it collided with the ground. One witness indicated that the…Jul 10, 1987 · N23JA · Substantial damageNTSB SEA87LA163Accident · No injuriesLimited investigationFinal reportCessna T-207 · Mccall, IDDuring climb out to cruise altitude the pilot noticed a drop in manifold pressure and a loss of oil pressure. The pilot was in the process of attempting to reach an airstrip when the oil pressure dropped to zero followed by a total loss of power. An off…Jul 9, 1987 · N6385H · Substantial damageNTSB NYC87IA199Incident · No injuriesIncident investigationFinal reportDouglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)A Mcdonnell Douglas DC-10 (viasa flt 800) & an Airbus A310 (pan am flt 221) were involved in a near collision while on intl flts ovr the Atlantic Ocean on (airway) amber 300. Both acft were operg under IFR & were in a non-radar environmentw/o drct radio ctc…Jul 9, 1987 · YV135 · 2 aircraft · No damageNTSB MKC87LA133Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mcdougal, ARThe ag airplane was on takeoff roll when the pilot smelled smoke in the cockpit. He stopped the airplane and turned off the fuel and switches before evacuating the airplane. He said the flames were coming from the cowling around the engine. Due to the total…Jul 9, 1987 · N6609Q · DestroyedNTSB MIA87LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Miami, FLA us customs blackhawk helicopter intercepted the acft after mistakenly identifing it as a suspected drug smuggling acft. After the acft landed at a gliderport on the edge of the everglades, the helicopter swooped down in the vicinity of the acft & blew it…Jul 9, 1987 · N6852J · Substantial damageNTSB LAX87LA259Accident · No injuriesLimited investigationFinal reportCessna 150M · Cameron Park, CADuring a pleasure flt, the non certificated plt landed the acft short of the rwy when he mistook a road for the rwy. The plt stated that the sun was in his eyes and by the time he realized that he was not landing on the rwy the acft was too low and slow to go…Jul 9, 1987 · N3811V · Substantial damageNTSB FTW87LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Midland, TXDuring takeoff roll from mid-field on the wrong runway, the pilot realized he was running out of runway. He rotated the aircraft early and climbed to approximately 10 feet AGL. The aircraft would not climb. The pilot aborted the takeoff andapplied brakes…Jul 9, 1987 · N5919V · Substantial damageNTSB FTW87LA165Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Venice, LAThe pilot was repositioning the aircraft after a phase iv inspection. The aircraft lifted off the pad and made several clockwise revolutions, descended out of control, impacted the ground and rolled over on its right side. Investigation revealed the number 1…Jul 9, 1987 · N5734S · Substantial damageNTSB DEN87LA176Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Bountiful, UTThe private pilot was practicing touch and go landing. The pilot reported the third landing was a wheel landing. Just after touchdown, adjacent to large petroleum tanks, the aircraft weather cocked to the right. The aircraft swerved right and departed the…Jul 9, 1987 · N8362H · DestroyedNTSB DEN87FA177Accident · Serious injuriesField investigationFinal reportCessna 152II · Parker, COThe instructor plt and his new student were on a local training flt when they encountered adverse wx. The instructor said that he attempted to turn back to the arpt but the winds forced the acft down until it impacted the ground.Jul 9, 1987 · N5269Q · Substantial damageNTSB ATL87LA207Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Crestwood, KYThe balloon contacted power lines as it was beginning to climb after an aborted ldg attempt. Electrical arcing ignited the propane fuel supply on board. The sole-occupant student plt jumped from the burning balloon and fell approx 40 ft onto a fence. The…Jul 9, 1987 · N2897H · Substantial damageNTSB ATL87LA206Accident · No injuriesLimited investigationFinal reportCessna 172I · Goodway, ALThe plt rprtd that he lndd long on a 2500 ft grass strip which was wet due to hvy dew. Drg the apch, he had an airspeed of 75 to 80 KTS with 30 deg of flaps. Subsequently, the acft slid off the departure end & struck a pecan tree. The recommended final apch…Jul 9, 1987 · N46233 · Substantial damageNTSB ATL87DEI08Accident · Minor injuriesFinal reportGrumman G-164A · Bucyrus, OHAs the plt was apchg a field to spread fertilizer, the acft collided with a tree & crashed to the ground. The plt received a head injury & said he could not recall the acdnt. According to hospital records, he was suffering from pneumonia & had a 101 deg temp…Jul 9, 1987 · N7845 · Substantial damageNTSB SEA87LA136Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lester, WADuring landing roll onto the closed runway the aircrafts right wingtip struck a post. The airport was notamed closed but no x's had been marked on the runway.Jul 8, 1987 · N85591 · Substantial damageNTSB MKC87FA131Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Holdrege, NEWitnesses stated that the aircraft was performing a loop when the left wing failed upward and rearward causing the aircraft to plummet to the ground, out of control. The aircraft appeared to have been in trouble during the loop entry and throughout the…Jul 8, 1987 · N87099 · DestroyedNTSB MIA87LA201Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Naples, FLThe plt stated that his aprch speed was too fast & he touched down about half way down the 3400 ft rwy. Believing that he would not get stopped during the ldg roll, he attempted to go around, but the gear struck a fence near the end of the rwy & dragged the…Jul 8, 1987 · N5005E · Substantial damageNTSB LAX87LA262Accident · No injuriesLimited investigationFinal reportPiper PA-31T2 · Novato, CAAt the end of a cross country flt, the plt reported that he had extended the landing gear aprx 5 miles from the arpt and lowered partial flaps. Aprx 2 miles from the arpt the plt made shallow s turns for spacing and extended the rest of the flaps. The plt…Jul 8, 1987 · N38WA · Substantial damageNTSB LAX87LA258Accident · No injuriesLimited investigationFinal reportCessna 172 · Hawthorne, CADrg an apch to rwy 25, the acft collided with the omni directional apch lighting system (odals). The plt indcd that she enctrd a downdraft on short final & applied full power; however, the acft contd to dscnd & struck one of the odals light cover lenses with…Jul 8, 1987 · N1466U · Substantial damageNTSB LAX87IA260Incident · No injuriesIncident investigationFinal reportMBB BK117A-3 · Cupertino, CAA Mbb BK117A-3 helicopter collided with wires while on final approach to an asphalt road in close proximity to a traffic accident. Night VMC prevailed at the time. The pilot indicated that he did not see the wires and was unaware of the collision until he was…Jul 8, 1987 · N160BK · Minor damageNTSB FTW87LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Baton Rouge, LAThe plt rprtd that after taking off to practice touch & go lndgs, the eng lost pwr. He atmtd to make a forced lndg on the arpt, but was unable. While lndg short of the rwy, the acft hit the top of a tree & the arpt security fence. Maintenance had just been…Jul 8, 1987 · N8485L · Substantial damageNTSB FTW87LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Tulsa, OKDrg the initial climb after takeoff, the acft's eng lost pwr. The plt landed the acft on a median in a residential & shopping area, where it nosed over. An exam & an opnl check of the eng revealed no reason for the loss of pwr.Jul 8, 1987 · N1175C · Substantial damageNTSB DEN87LA183Accident · No injuriesLimited investigationFinal reportCessna T188C · Winnett, MTDuring landing on a roadway used by the crop-duster for re-loading chemicals for spraying, the left spray boom contacted vegetation and slewed the acft sideways. The right wing was bent and the propeller was damaged.Jul 8, 1987 · N2058J · Substantial damageNTSB DEN87LA175Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Nimbus II · Hobbs, NMThe pvt plt was flying in a national soaring contest. The glider was towed to 2000 feet AGL and released. The plt reported making a climbing right turn after release, however he noticed that the control stick was more aft than normal. As the flight…Jul 8, 1987 · N71JD · Substantial damageNTSB CHI87DER08Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring a 180 degree turn from completion of a spray swath the aircraft began to sink. The pilot dumped his load and added power, however was unable to arrest sink. When it was obvious that impact with the ground was imminent, the pilot reduced power and…Jul 8, 1987 · N9674J · Substantial damageNTSB ATL87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gulf Shores, ALThe plt aborted the takeoff about half way down the 3600 ft rwy after observing that the airspeed indicator was inop. Before he could stop the acft, it ran off the end of the rwy & went into a ditch. An exam by an A&P mechanic revealed that the pitot head was…Jul 8, 1987 · N8389Y · Substantial damageNTSB ATL87LA204Accident · No injuriesLimited investigationFinal reportBell 47D1 · Huntsville, ALThe aerial application flight was dispensing insecticides on a cotton field. While maneuvering to avoid powerlines during the procedure turnaround following an upwind swath run, the pilot failed to maintain sufficient airspeed to ensure effective…Jul 8, 1987 · N908B · Substantial damageNTSB ATL87DLT02Accident · Minor injuriesFinal reportGulfstream-Schweizer G164B-600 · Union City, TNThe ag-acft lost power while turning, shortly after departure from a field. During the subsequent forced ldg, the acft struck a fence and nosed over. The engine was torn from the acft during the impact sequence. Post-crash examination of the acft engine by an…Jul 8, 1987 · N8046K · Substantial damageNTSB LAX87FA257Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, CAPilot's failure to maintain adequate airspeed on final approach which resulted inthe aircraft stalling.Jul 7, 1987 · N7485D · DestroyedNTSB FTW87DRG03Accident · Serious injuriesFinal reportWayne Hooks Cassutt III-M · Burnet, TXOn July 7,1987, a cassutt 111M, N3790A, impacted the runway at kate craddock field (T-27) Burnet Texas. The pilot was conducting the initial test flight of the home built aircraft when the canopy came open. The pilot attempted to land the aircraft while…Jul 7, 1987 · N3790A · Minor damageNTSB FTW87DRD08Accident · No injuriesFinal reportGrumman G-164A · Lacassine, LAThe pilot stated the aircraft's tail wheel broke during the takeoff roll causing the aircraft to veer to the right. The right wing contacted a small tree and the right main gear wheel dropped into a ditch which was parallel with the runway. Directional…Jul 7, 1987 · N9778 · Substantial damageNTSB ATL87IA201Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Frankfort, KYThunderstorms and lightning in the vicinity of the arpt prevented adding fuel to the acft and resulted in a delayed departure. The lou VOR was out of service, and the flt was radar vectored until it was cleared direct to lex and for the apch. At the time of…Jul 7, 1987 · N324DL · No damage