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 ANC88LA136Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot was an aircraft mechanic for the operator of the airplane, and was enroute to another airport to repair a company airplane. The pilot stated that he did not do a complete job of preflighting the airplane, and attempted to takeoff with the control…Sep 10, 1988 · N6470H · Substantial damageNTSB SEA88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAPlt landed with 80 deg right cross wind of 8 KTS, groundlooped to right. The plt said that ATIS info gave the wind as 220 degrees at 8 KTS; however his EST from windsock observation included gusts of 15 KTS. The observing station reported no gusts on the date…Sep 9, 1988 · N2526A · Substantial damageNTSB SEA88LA174Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Gasquet, CAThe pilot stated that as he turned final approach, intense sunglare was encountered. The plt executed a go-around 'in the blind,' and collided with trees in approach path. The acft remained flyable and the pilot diverted to medford, Oregon.Sep 9, 1988 · N8541P · Substantial damageNTSB NYC88FA235Accident · 3 fatalField investigationFinal reportCessna 182RG · Greenville, METhe non-instrument rated pilot apparently could not locate the destination airport because of low ceilings and ground fog. Before the pilot started his trip he was advised by the fss that VFR flight to his destination was not recommended. It appears that the…Sep 9, 1988 · N6064C · DestroyedNTSB CHI88FA233Accident · No injuriesField investigationFinal reportBoeing 727-200 · Minneapolis, MNFailure of the captain to follow company pushback procedures and not getting a release before starting to taxi.Sep 9, 1988 · N729RW · Substantial damageNTSB ATL88DKG18Accident · No injuriesFinal reportGrumman G-164B · Smithville, GASoon after takeoff from a private sod airstrip for aerial application maneuvering, the engine lost power. The plt was forced to land in soft muddy terrain where the acft nosed over. Post acc invest revealed that the float assy in the carburetor jammed which…Sep 9, 1988 · N8132K · DestroyedNTSB ANC88LA132Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Fairbanks, AKThe commercial pilot had dropped two hunters off at their campsite, and was taxiing for takeoff on an unlighted gravel bar at dusk. He misjudged the end of the gravel bar in the fading light and taxied off a four foot embankment.Sep 9, 1988 · N362X · Substantial damageNTSB ANC88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe commercial pilot attempted to takeoff from a rough and soft off-airport site in rural Alaska. During the takeoff roll, the airplane's main landing gear encountered an exceptionally soft spot, causing the airplane to nose over. The pilot stated that the…Sep 9, 1988 · N1759P · Substantial damageNTSB NYC88DHA04Accident · 1 fatalFinal reportBanks/Mong Sport · Marshalls Creek, PAThe homebuilt airplane impacted the ground in a steep nose down attitude among three tall pine trees. After impact, it bounced back about three feet & came to rest. There was no damage to the trees. An exam of the prop revealed no evidence of the engine…Sep 8, 1988 · N25JJ · Substantial damageNTSB MKC88LA169Accident · No injuriesLimited investigationFinal reportCessna 195 · Keokuk, IAThe new owner of the acft asked the former owner to ride with him in the right seat while doing some touch and go landings. After the first circuit the former owner said he felt the pilot needed additional training before attempting to fly the acft as PIC.…Sep 8, 1988 · N3040B · Substantial damageNTSB LAX88LA313Accident · No injuriesLimited investigationFinal reportCessna 172K · Fresno, CAThe pilot stated that he had mistakenly lined up for final approach on taxiway rather than runway 29L as instructed. When he was on short final the control tower informed him of his mistake. While maneuvering to line up on runway 29L, the pilot lost control…Sep 8, 1988 · N79226 · Substantial damageNTSB LAX88FA314Accident · 1 fatalField investigationFinal reportCessna 177RG · San Luis Obispo, CAPilots erroneous interpretation of his missed approach clearance, and, his performance of the published missed approach procedure for the santa maria ILS instead of the San Luis Obispo localizer.Sep 8, 1988 · N33283 · DestroyedNTSB LAX88FA312Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Camarillo, CAThe pilot decided to operate the aircraft with a known electrical deficiency during night instrument meteorlogical conditions and the decision of the pilot to conduct a flight operation in which he was not certified. Contributing to this accident was the…Sep 8, 1988 · N8743W · DestroyedNTSB CHI88LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Watertown, WIThe pilot in command's improper selection of the fuel tank, and his subsequent failure to maintain control of the aircraft.Sep 8, 1988 · N9346C · DestroyedNTSB MIA88FA267Accident · 4 fatalField investigationFinal reportBeech K35 · Morriston, FLThe student pilot was about 47 miles from home and nearing completion of a x-c flt with his wife, father, and mother. The plt had reqsted VFR flight following & had been cruising at 6500 ft. the plt advised ATC they were down to 6250 ft & needed to descend…Sep 7, 1988 · N9525R · DestroyedNTSB FTW88DPA07Accident · No injuriesFinal reportBölkow BO-105C · Dallas, TXThe helicopter made its approach to an open area on the westside of the airport to go to a refueling area on the south side of the airport. The pilot changed his mind and decided to go to the northeast side of the airport. He received tower approval but was…Sep 7, 1988 · N210BB · Substantial damageNTSB CHI88LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Cambridge, OHThe pilot was on a solo flight for the purpose of practicing takeoffs and landings. The aircraft departed the right side of the runway and struck a culvert. The flight was the pilot's second supervised solo.Sep 7, 1988 · N7118F · Substantial damageNTSB ANC88LA128Accident · No injuriesLimited investigationFinal reportCessna 180H · Figure 8 Lake, AKThe private pilot and his passenger were uninjured following a forced landing on a survey trail. The pilot related that the airplane ran out of fuel, and nosed-over during the landing roll on the soft soil. He said that he did not visually inspect the…Sep 7, 1988 · N2483F · Substantial damageNTSB SEA88LA173Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Priest River, IDOn approach for lndg on rwy 27, the plt noted that the windsock was indicating strong, shifting winds. The acft settled in the flare, despite added power, resulting in hard landing.Sep 6, 1988 · N56312 · Substantial damageNTSB SEA88LA172Accident · No injuriesLimited investigationFinal reportYoung-Owens Cassutt 3M · Caldwell, IDOn test flt in preparation for reno air races, plt entered power dive at 10000 ft to 230 KTS and experienced vibrations. He reduced power and entered a steep nose high climb allowing the aircraft to decelerate to near stall speed. The vibration continued. At…Sep 6, 1988 · N67Y · DestroyedNTSB MKC88LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, IAArriving at the destination apt, on a solo cross country flt, the plt said UNICOM advised a landing on rwy 18. The local fss reported the winds to be out of the northwest favoring runway 36. The plt elected to land on rnwy 18 based on the UNICOM advisory, and…Sep 6, 1988 · N5458P · Substantial damageNTSB MIA88LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Punta Gorda, FLThe plt was returning from VFR xc flt during which many climbs, descents & detours were made to avoid adverse wx & maintain VFR. He stated the strong headwinds considerably reduced his grndspeed. At his 1st intended ldg arpt, strong gusty x-winds made the…Sep 6, 1988 · N8670P · Substantial damageNTSB ATL88LA248Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Calera, ALThe plt reported that the engine lost power during descent. The airplane subsequently crashed into a cornfield after clearing a row of trees, as the plt was attempting to make a forced landing. Post-crash exam of the airplane revealed that both the main & aux…Sep 6, 1988 · N24487 · Substantial damageNTSB ANC88LA130Accident · No injuriesLimited investigationFinal reportCessna 182TD · September Lake, AKThe 202 hour private pilot was attempting to takeoff in a Cessna 182 converted to a conventional configuration (taildragger) from an off-airport site in rural Alaska. The pilot reported that a strong, gusty crosswind pushed the airplane off the intended track…Sep 6, 1988 · N5369B · Substantial damageNTSB ANC88LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Oshetna River, AKThe pilot reported that he was attempting to takeoff from an extremely narrow and short stretch of land situated near a River. He had used this off-airport, unimproved site for several years without difficulty until the accident flight. On this occasion, the…Sep 6, 1988 · N234E · Substantial damageNTSB ANC88LA127Accident · No injuriesLimited investigationFinal reportMaule M-4 · Eureka Creek, AKDuring the takeoff roll on an upsloping gravel airstrip, the pilot lost control of the airplane. The airplane nosed over on its back. The pilot and both passengers exited the airplane without injuries.Sep 6, 1988 · N12020 · Substantial damageNTSB SEA88LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Leavenworth, WAOn initial climb over trees bordering 2500-FT mountain strip, plt experienced sudden and severe wind gusts beyond his capability to counter. Acft collided with trees and terrain.Sep 5, 1988 · N2811Q · Substantial damageNTSB SEA88LA170Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Toledo, WAThe pilot aborted the first takeoff due to the engine not developing full power. After another run up, the pilot elected to make another takeoff. The pilot aborted midfield, by retarding the power and applying heavy braking, due to the aircraft not developing…Sep 5, 1988 · N9559L · Substantial damageNTSB SEA88FA169Accident · 4 fatalField investigationFinal reportCessna 172E · Petersburg, AKPlt was briefed for marginal VFR conditions. Witnesses on departure noted fog bank offshore from airport. Witnesses near accident site, 10 mi from departure point, heard acft and sounds of impact. They reported fog on the water and glassy water conditions.Sep 5, 1988 · N3841S · DestroyedNTSB SEA88FA167Accident · 1 fatalField investigationFinal reportBritten-Norman BN-2A · Sitka, AKThe pilot encountered low ceilings, rain and fog while attempting to fly through a narrow mountain pass and successfully reversed course. He then flew into a small canyon off the main pass that terminated in a small glacier-covered bowl surrounded by steep…Sep 5, 1988 · N111VA · DestroyedNTSB MIA88LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Waynesboro, MSWhile cruising at 5500 ft, the plt smelled burning oil. Moments later, oil press was lost, the prop went into high RPM & the tach zoomed over redline. A loud report was heard & all power was lost. A forced ldg was attempted in the rolling country but the acft…Sep 5, 1988 · N43046 · Substantial damageNTSB FTW88LA163Accident · No injuriesLimited investigationFinal reportAmerican AA1B · Houston, TXShortly after liftoff, the engine lost power and the pilot turned toward a field. The nose wheel struck a levee and the airplane flipped inverted. During a post-crash inspection, a large mud dauber nest was found inside the air induction system, just behind…Sep 5, 1988 · N6208L · Substantial damageNTSB FTW88FA162Accident · 1 fatalField investigationFinal reportCessna 172P · Marietta, OKThe plt elected to land on rwy 17 with wind from 300 degrees at 6 knots. During the second go-around the airplane's left wing struck a tree at a point 30 feet above the ground and the aircraft ended up inverted in a parking lot. Plt stated he had landed at…Sep 5, 1988 · N99144 · DestroyedNTSB DEN88FA199Accident · 1 fatalField investigationFinal reportGlasflugel H-301 · Salida, COWitnesses said the acft was aprx 200 ft AGL on the downwind leg, but close in to the rwy as it returned to the arpt for landing. Acft entered a 60 deg right bank to base leg. Nose rose slightly and acft rolled inverted. Acft made one-half to three-quarters…Sep 5, 1988 · N71949 · DestroyedNTSB CHI88FA203Accident · 2 fatalField investigationFinal reportPiper PA-20 · Claypool, INPilot-in-command's failure to maintain a sufficient visual lookout and perform a pull up in time to avoid collision with a tree.Sep 5, 1988 · N7791K · DestroyedNTSB CHI88DER14Accident · 1 fatalFinal reportHomebuilt Woodstock · Mankato, MNAircraft structural failure due to overload induced by pilot in the performance of unauthorized maneuvers.Sep 5, 1988 · N369DK · DestroyedNTSB CHI88DER13Accident · No injuriesFinal reportPiper PA-22-150 · Cohasset, MNFailure of the PIC to maintain a proper glide path in order to clear obstructions along the flight path of his final approach.Sep 5, 1988 · N7222D · Substantial damageNTSB ATL88LA249Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Saluda, SCThe instructor pilot reported that they were conducting autorotation training. During an autorotation the crew delayed initiating the power recovery. The helicopters struck the ground causing substantial damage. The pilots did not report experiencing a system…Sep 5, 1988 · N8823F · Substantial damageNTSB ATL88LA246Accident · No injuriesLimited investigationFinal reportCessna 182K · Hendersonville, NCThe pilot was nearing touchdown on a normal landing when the left side of the windscreen was struck by a bird. The startled pilot was distracted long enough for the aircraft to bounce on the runway. Elevator control was lost after the first bounce. A nose low…Sep 5, 1988 · N2636R · Substantial damageNTSB ANC88LA126Accident · No injuriesLimited investigationFinal reportStinson 108 · Mt Spur, AKAt 1500 feet m.s.l. a complete engine failure occurred. An emergency landing was made on a gravel bar. During the rollout the airplane collided with a gravel bank. An on site examination of the engine revealed a hole in the case next to the left exhaust…Sep 5, 1988 · N97326 · Substantial damageNTSB ANC88LA125Accident · No injuriesLimited investigationFinal reportCessna 180K · Chickaloonflats, AKOn touchdown off shore on the mud flats, the pilot lost complete control of the airplane. The airplane then nosed over on its back.Sep 5, 1988 · N2989K · Substantial damageNTSB MIA88LA271Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lake Wales, FLThe plt stated he approached the 2,450 ft grass airstrip from the NE & circled north of it to observe the windsock. The wind appeared to be from the east. The pilot entered the pattern to land on rwy 36. While flaring to land the acft floated down the rwy &…Sep 4, 1988 · N722TC · Substantial damageNTSB LAX88FA309Accident · 2 fatalField investigationFinal reportCessna 150J · Hemet, CAPilot's failure to maintain an airspeed at which the aircraft is controllable. Gusty winds, high density altitudes and the failure of the pilot to obtain a preflight weather briefing and to conduct an evaluation were factors in the accident.Sep 4, 1988 · N60547 · DestroyedNTSB LAX88FA308Accident · 1 fatalField investigationFinal reportCessna 150F · Chino, CAPilot's in flight loss of control of the aircraft during a banner pickup sequence.Sep 4, 1988 · N7093F · DestroyedNTSB LAX88FA307Accident · 4 fatalField investigationFinal reportCessna 172 · Grand Canyon, AZThe pilot failed to maintain control of the aircraft during nigh visual meteorological conditions. Contributing to this accident was the pilot's lack of recent experience at nigh and the lack of outside visual references due to darkness.Sep 4, 1988 · N54814 · DestroyedNTSB FTW88FA161Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · Carthage, TXDrg a night arrival, the plt rprtd he could make a visual apch. At 2341:37 CDT, the ARTCC controller informed him the destn arpt was straight ahead at 12 mi & requested that he rprt when the arpt was in sight. At 2343:30, he rprtd the rwyin sight & the…Sep 4, 1988 · N83874 · DestroyedNTSB DEN88LA200Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX8-90 · Las Cruces, NMThe commercial balloon plt was participating in a balloon rally. During landing, the plt noticed the balloon was drifting toward power lines. He elected to open the deflation valve at 30 ft AGL, to attempt to land short of the lines. The balloon touched down…Sep 4, 1988 · N90EH · Substantial damageNTSB CHI88LA236Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Hinckley, ILDuring the initial climbout on the dual instructional flight, as the glider was towed through approximately 50-100' AGL, the tow rope failed. The instructor pilot executed a hard forced landing at the edge of a cornfield located to the right side of the…Sep 4, 1988 · N3613F · Substantial damageNTSB CHI88FA231Accident · 1 fatalField investigationFinal reportCessna 172P · Boyne City, MIThe pilot and his passenger were flying low over a sailboat regatta to photograph sailboats. As the pilot maneuvered for a photograph, he throttled back and banked the aircraft in a steep bank. Subsequently, the aircraft stalled and there was insufficient…Sep 4, 1988 · N52601 · DestroyedNTSB ATL88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, TNThe pilot reported that while in cruise flight he had a partial then total electrical failure. During the off- airport emergency landing on a wet, grassy field, the pilot was unable to stop before sliding into a culvert. Examination of the airplane revealed…Sep 4, 1988 · N1281T · Substantial damage