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 NYC88DGM01Accident · 1 fatalFinal reportHiller UH-12E · Lovely, PAThe undetermined loss of engine power while performing low level aerial application operations.Aug 4, 1988 · N5375V · Substantial damageNTSB MIA88LA246Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Glen Allen, MSAccording to FAA personnel while returning to land during an aerial application flt, the eng quit due to fuel exhaustion. The acft was damaged drg the forced landing.Aug 4, 1988 · N3659G · Substantial damageNTSB FTW88LA143Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dalhart, TXAs the ag airplane tried to level off at the start of the spray run, it continued the descent into the corn and flipped forward to the inverted position. The elevation in the area was 4100 ft MSL and the density altitude was 5000 ft.Aug 4, 1988 · N9248R · DestroyedNTSB DEN88LA175Accident · No injuriesLimited investigationFinal reportBraswell Scirroco MJ5-K2 · Hurricane, UTThe plt said he made a short flt to check out a mag. The eng performed satisfactorily and he landed. Upon touchdown one of the main landing gear collapsed and the tailwheel equipped acft ground looped. The plt said a gear downlock failed. The FAA…Aug 4, 1988 · N6XY · Substantial damageNTSB DEN88LA172Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Guffey, COAug 4, 1988 · N182VR · DestroyedNTSB DEN88LA171Accident · No injuriesLimited investigationFinal reportCessna 150 · Albuquerque, NMThe instructor (CFI) & student plt were on an instructional flt. The CFI rprtd that while climbing thru aprx 150' AGL, the acft enctrd a downdraft. He took the controls, but the acft descended to about 10 ft AGL. The CFI elected to land immediately to avoid a…Aug 4, 1988 · N704UN · Substantial damageNTSB CHI88LA191Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · St. Charles, MIThe pilot failed to attain sufficient altitude to clear obstacles during the initial climb-out and the aircraft collided with trees located off the departure end of the private grass strip. The aircraft fell to the ground, where it caught fire and was…Aug 4, 1988 · N97797 · DestroyedNTSB BFO88LA072Accident · No injuriesLimited investigationFinal reportPiper PA-30-160R · Chantilly, VAThe instr & stu plt were doing a practice landing on rwy 27 at the front royal airport when the acft landed hard and bounced about 20 ft high. A go around was made, however, the landing gear would not retract. After two flyovers of the arpt it was confirmed…Aug 4, 1988 · N7866Y · Substantial damageNTSB BFO88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisonburg, VAThe plt encountered clouds during a night VFR flight. He decided to make a precautionary lndg on what he thought was a lighted farm landing strip. However, he later learned the strip was actually a row of lighted turkey barns. According to the plt, as he made…Aug 4, 1988 · N1665A · Substantial damageNTSB SEA88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe student pilot was practicing touch and go landings. On the eighth landing the aircraft bounced. The pilot stated that he lost control of the aircraft during the attempted recovery. The aircraft departed the runway and collided with a power company meter.Aug 3, 1988 · N4651P · Substantial damageNTSB NYC88LA208Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Auburn-Lewiston, METhe student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170.Aug 3, 1988 · N169WS · Substantial damageNTSB NYC88FA202Accident · 2 fatalField investigationFinal reportCessna 172P · Post Mills, VTThe plt flew the acft to an arpt with two turf rwys. Rwy 5/23 was 2300' long & rwy 4/22 was 2600' long. After attending a meeting which ended at 1600 EDT, the plt elected to wait until later in the day to takeoff after the air had cooled. Subsequently, he…Aug 3, 1988 · N62541 · DestroyedNTSB NYC88DHJ01Accident · Serious injuriesFinal reportStolp Starduster SA-300 · Shirley, NYThe plt rprtd that the acft's eng lost power as he was departing from rwy 24. He said he turned left to land on rwy 15, then the eng restarted again, so he decided to land on rwy 24. Also, he rprtd that as he was banking to the left in the traffic pattern,…Aug 3, 1988 · N7613 · DestroyedNTSB MKC88FA147Accident · 2 fatalField investigationFinal reportMooney M20C · Missouri City, MOThe co-owner of the acft stated he had experienced a fuel flow pblm while flying to the (ojc) arpt, where pax (one of them was a co-owner) were to board. He stated he advzd the other owner of the pblm, but no corrective action was taken. The acft was then…Aug 3, 1988 · N6528U · Substantial damageNTSB MIA88LA245Accident · No injuriesLimited investigationFinal reportStanford Monofly · Jacksonville, FLFlt experienced total loss of engine power while on a downwind position for landing. The runway could not be reached and a forced landing was made in trees. The fuel pump was mounted directly to the engine block and auto fuel was being used. After the…Aug 3, 1988 · N70061 · Substantial damageNTSB MIA88FA244Accident · Serious injuriesField investigationFinal reportCessna 150M · Pahokee, FLThe acft crashed while the plt was attempting a touch and go landing at Pahokee airport, Pahokee FL. The plt stated that when he landed on runway 17, the acft bounced. As he was attempting a go around, he lost control. The acft stalled, broke left, and…Aug 3, 1988 · N63354 · DestroyedNTSB LAX88LA279Accident · No injuriesLimited investigationFinal reportMooney M20E · Visalia, CAThe pilot removed the vacuum pump from the engine prior to the flight because of an internal failure in the pump. The pilot did not install a cover plate on the accessory mounting hole vacated by the pump. After takeoff on the local flight, the pilot noticed…Aug 3, 1988 · N9273M · Substantial damageNTSB LAX88DUM06Accident · No injuriesFinal reportHiller UH12E · Bard, CADuring helicopter aerial application, engine power was lost. Plt applied back cyclic and tail rotor contacted terrain, followed by hard landing. Investigation revealed less than useable fuel remaining.Aug 3, 1988 · N14633 · Substantial damageNTSB DEN88LA173Accident · Serious injuriesLimited investigationFinal reportCessna 195B · Watkins, COThe new owner of the acft was receiving flt training from an instructor (CFI) & they were practicing landings. Drg a landing roll-out, the acft began to veer to the right. The CFI took the controls to avoid running off the rwy, then took off & flew another…Aug 3, 1988 · N195RC · Substantial damageNTSB CHI88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIAug 3, 1988 · N93411 · Substantial damageNTSB CHI88FA188Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Flushing, MIPilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.Aug 3, 1988 · N2956Z · DestroyedNTSB CHI88DEV04Accident · No injuriesFinal reportGrumman G164A · Chenoa, ILUnavailability of suitable terrain on which to accomplish a forced landing.Aug 3, 1988 · N8980H · Substantial damageNTSB ATL88LA225Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · N. Myrtle Beach, SCThe plt reported that he made a low pass over the banner staging area to drop a banner; the release mechanism in the cockpit failed to operate and the banner remained in tow. Xwind conditions blew the banner into another banner on the ground which was…Aug 3, 1988 · N9692S · Substantial damageNTSB ATL88DLT01Accident · 1 fatalFinal reportVan RV-4 · Ashland City, TNAug 3, 1988 · N223RD · DestroyedNTSB ANC88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe private pilot reported that he was attempting to land at an unimproved, off-airport landing site near Delta Junction, AK. The landing area that he selected was muddier than he had anticipated, and the airplane decelerated too rapidly and nosed over,…Aug 3, 1988 · N1192C · Substantial damageNTSB MKC88LA148Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tarry, ARThe pilot said the engine quit abrubtly during an aerial application turn around maneuver. He attempted to land in a nearby farm field and because of the soft terrain conditions, the acft nosed over during the roll out. Post accident investigation revealed a…Aug 2, 1988 · N3682X · Substantial damageNTSB MKC88LA146Accident · Minor injuriesLimited investigationFinal reportVarga 2150A · Washington, IAWhile enroute the PIC rptd a loss of eng pwr. The PIC stated in his rpt that having passed Washington, IA, he switched fuel tanks to draw fuel from the lft tank which indicated 1/2 full. Shortly after switching, the PIC stated the tank went empty. The PIC…Aug 2, 1988 · N8259J · Substantial damageNTSB MIA88WA251Accident · Minor injuriesForeign investigationPiper PA-31-325 · El Porvenir, PanamaAug 2, 1988 · N300HL · Substantial damageNTSB MIA88LA243Accident · No injuriesLimited investigationFinal reportCessna 180J · Pahokee, FLThe plt stated that he was attempting a wheel landing. On rollout he 'hit' the brakes. The acft nosed over and came to rest inverted.Aug 2, 1988 · N9962N · Substantial damageNTSB MIA88LA242Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Greenville, MSThe pilot reported that while on short final during a personal flt, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a levee, small trees, then the terrain.Aug 2, 1988 · N1948W · Substantial damageNTSB LAX88FA278Accident · 1 fatalField investigationFinal reportCessna T-210 · Brea, CAAug 2, 1988 · N79Y · DestroyedNTSB FTW88LA142Accident · No injuriesLimited investigationFinal reportBeech A36TC · Vega, TXUnreported propeller strike.Aug 2, 1988 · N3707Z · Substantial damageNTSB DEN88FA170Accident · 1 fatalField investigationFinal reportBeech B23 · Cimarron, NMThe pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.Aug 2, 1988 · N4006T · DestroyedNTSB CHI88FA190Accident · 2 fatalField investigationFinal reportMcdonnell Douglas 269B · Braceville, ILConducting maneuvering flight the PIC failed to monitor the helicopter systems and allowed the main rotor RPM to decay to the point where it would not produce enough lift to sustain flight.Aug 2, 1988 · N9522F · DestroyedNTSB CHI88DEI03Accident · Minor injuriesFinal reportPiper PA-28-140 · Salem, OHThe airplane engine failed to respond when the throttle was advanced during the recovery from a practice forced landing. The airplane struck wires while attempting to reach a suitable landing area during the resulting forced landing. The wires did not break;…Aug 2, 1988 · N7024R · Substantial damageNTSB ATL88LA224Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Reidsville, NCThe student plt rprtd that while landing, the airplane began to veer to the left. Subsequently, it ran off the left side of the rwy & into a ditch. A crosswind was blowing from the left at the time. The operator rprtd that tire marks from the nose & right…Aug 2, 1988 · N26045 · Substantial damageNTSB NYC88LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsville, PAEngine power loss due to fuel starvation which resulted in an emergency landing in a field.Aug 1, 1988 · N4609L · DestroyedNTSB MIA88IA240Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Pensacola, FLThe captain stated that he crossed the final approach fix at 3000 feet, continued the approach, touched down at 140 knots at the end of the touchdown zone, but could not stop the acft and ran off the end of runway 16. According to tower personnel and…Aug 1, 1988 · N924DL · No damageNTSB CHI88LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Cheboygan, MIShortly after departure, when the aircraft was approximately 30' in the air, the aircraft's right wing 'dropped hard'. The pilot attempted remedial action, but was unable to regain control of the aircraft before the right wing tip struck the ground. The…Aug 1, 1988 · N4982Z · Substantial damageNTSB CHI88LA185Accident · No injuriesLimited investigationFinal reportCessna 172N · Xenia, OHAug 1, 1988 · N2282E · Substantial damageNTSB CHI88FAMS2Accident · Serious injuriesMissing aircraftFinal reportMooney M20K · Racine, WIEngine failure due to fuel starvation.Aug 1, 1988 · N56352 · DestroyedNTSB CHI88DEP08Accident · No injuriesFinal reportMonnett Sonerai II · Wisc Rapids, WIThe plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…Aug 1, 1988 · N79TG · Substantial damageNTSB BFO88LA070Accident · No injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEThe plt was in the process of picking up a banner when the aircraft stalled and crashed into a wooded area. The banner was picked up at an airspeed of 80 mph and the acft altitude was increased to 250 ft AGL. The pilot reported that the wings of the acft…Aug 1, 1988 · N5682G · Substantial damageNTSB ATL88LA223Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Laurens, SCThe plt rprtd that when he landed, everything seemed normal until he was lowering the nose to the rwy drg the landing roll. At that time, the left wing began to settle. At first, he thought the left tire was going flat, but the settling continued.…Aug 1, 1988 · N8191J · Substantial damageNTSB ANC88LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Valdez, AKThe private pilot was attempting to land at a remote beach site to join a pilot friend who had landed there earlier in his own airplane. The pilot on the beach had placed a sleeping bag and other items in a hole on the beach to mark it as a landing hazard.…Aug 1, 1988 · N8580D · Substantial damageNTSB NYC88FA248Accident · 2 fatalField investigationFinal reportPiper PA-39-30 · Margaretville, NYThe acft departed block island, RI en route to stewart international airport, newburgh, new york, the aircraft never arrived and was reported missing August 2, 1988. The aircraft was missing until November 21, 1988 when it was found near Margaretville, NY by…Jul 31, 1988 · N2875A · DestroyedNTSB MKC88LA143Accident · No injuriesLimited investigationFinal reportCessna 188 · York, NEEn route to perform an aerial application operation, the plt said he experienced a partial power loss followed by complete power failure. He attempted an emergency ldg in a farm cornfield, substantially damaging the acft. An on scene investigation by the FAA…Jul 31, 1988 · N21779 · Substantial damageNTSB LAX88LA276Accident · Serious injuriesLimited investigationFinal reportRaven RX-6 · Sun City, CAThe pilot & pax departed on a local area balloon flt. After 30 minutes the pilot began a descent to an open feild north of some power lines. During the descent the balloon began to drift to the right and the pilot realized that his ground crew did not have…Jul 31, 1988 · N1183R · Substantial damageNTSB LAX88FA277Accident · 1 fatalField investigationFinal reportCessna 414A · Big Pine, CAThe pilot intentionally flew over an area of high terrain in which he failed to maintain the proper altitude and he delayed his decision to reverse course. A contributing factor was the pilot's improper in-flight decision.Jul 31, 1988 · N414YV · DestroyedNTSB DEN88LA164Accident · No injuriesLimited investigationFinal reportStinson 108 · Lordsburg, NMDuring takeoff the plane swerved to the lt and the plt aborted the takeoff. On the second takeoff, the airplane again swerved lt and departed the rwy. The plane entered loose sand off the lt side of the rwy and nosed over. The plt stated that he had made 10…Jul 31, 1988 · N97395 · Substantial damage