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 LAX88DVA02Accident · Minor injuriesFinal reportBell UH-1B · Arvin, CAMar 14, 1988 · N59368 · DestroyedNTSB ATL88IA117Incident · No injuriesIncident investigationFinal reportAero Commander 680E · New York, NYThe airplane had been given a daily insp on 03-10-88 with no structural damage noted. During the next daily inspection on 03-14-88, skin buckling was noted on both wings. Three different pilots had flown the airplane between inspections and all indicated that…Mar 14, 1988 · N50 · Minor damageNTSB ATL88IA113Incident · No injuriesIncident investigationFinal reportCessna 172B · Elizabethton, TNDue to a low charge in the battery, the plt elected to start the eng by hand propping, so he could program the loran for a later flt. He began hand propping with the tail & left wing tied down. After the eng started, the tiedown for the tail pulled loose &…Mar 14, 1988 · N7609X · Minor damageNTSB LAX88LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-201T · Bullhead City, AZShortly after takeoff, the engine failed. During the forced landing the aircraft ran into a rock quarry. Inspection of the engine revealed that the fuel injector lines were loose and that one line had separated.Mar 13, 1988 · N694ME · Substantial damageNTSB LAX88LA124Accident · No injuriesLimited investigationFinal reportCessna 180 · Corona, CAThe plt was completing a personal flt. During the landing roll the airplane began to swerve to the left. The plt reptd the rudder was ineffective due to the airplane's slow speed and she applied the brakes. Before the airplane came to a stop the left landing…Mar 13, 1988 · N2952A · Substantial damageNTSB DEN88LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMThe private plt and two pax attempted takeoff at or near max gwt at a density alt of 6,500 ft MSL. Full fuel had been loaded in the right tank and the plt indicated that the left tank was empty. Rwy 24 was in use with a 70 degree x-wind reported from 310…Mar 13, 1988 · N32982 · Substantial damageNTSB ATL88LA111Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Maiden, NCThe aircraft had been flying a series of low level maneuvers over the city. The pilot was attempting to recover from an intentional spin close to the ground when the aircraft struck utility lines and impacted the ground.Mar 13, 1988 · N23899 · Substantial damageNTSB SEA88LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Elma, WADuring landing roll the pilot applied toe brakes. The right brake pedal went to the floor. The aircraft then veered to the left of the centerline despite the pilots attempt to groundloop the aircraft. The aircraft then rolled over an embankment, collapsing…Mar 12, 1988 · N8374C · Substantial damageNTSB NYC88LA107Accident · No injuriesLimited investigationFinal reportCessna T210M · Greene, NYDuring takeoff roll, the aircraft drifted to the right edge of the runway in a soft-field takeoff attitude. The right main gear contacted the top of a snowbank. The aircraft then yawed to the right and impacted a second snowbank where it came to rest.Mar 12, 1988 · N761BU · Substantial damageNTSB FTW88LA079Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · La Porte, TXA pitts S-2A taxing from landing collided with a Cessna 150 that was stopped on the taxiway waiting as #2 for takeoff. The pitts CFI said the duel student, a private plt, was taxing the pitts from the rear seat. The Cessna was seen by the pitts plts during…Mar 12, 1988 · N31441 · 2 aircraft · Minor damageNTSB DEN88DQA03Accident · 2 fatalFinal reportSurline Sidewinder · Moriarty, NMWitnesses heard the acft eng sound increase dramatically as the acft passed over a gen aviation airport. The acft was seen by another witness at low atl, estimated to be about 200 ft, as the nose pitched up. The acft then entered a spin and impacted the…Mar 12, 1988 · N185SA · DestroyedNTSB ATL88FA110Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Rock Hill, SCThe plt and a certificated pilot/pax departed the Rock Hill apt for a local maint test flt following an engine overhaul and installation. About 10 minutes into the flt, the engine oil pressure dropped to zero and a complete loss of power followed. The plt…Mar 12, 1988 · N8727E · DestroyedNTSB NYC88LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Old Town, MEFollowing rollout from a normal landing in strong winds, and during a left turn onto the taxiway, the wing of the aircraft was lifted up by a quartering tailwind and flipped over.Mar 11, 1988 · N89219 · Substantial damageNTSB MIA88LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Jacksonville, FLThe pilot stated that he did not visually check the fuel quantity prior to departure on an aerial photography flight. About .9 hours after takeoff the engine failed due to fuel exhaustion. The pilot executed a forced landing and the aircraft crashed. Both the…Mar 11, 1988 · N22CE · Substantial damageNTSB LAX88LA126Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A-1 · Oceanside, CAThe non-U.S. Certificated pilot lost control of the helicopter while hovering 3-FT AGL during a maintenance test flight. The acft descended, touched down hard and rolled over. The non-english speaking pilot immediately departed the scene & reportedly headed…Mar 11, 1988 · N73969 · DestroyedNTSB LAX88LA122Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lower Lake, CADrg the lndg roll, the left main lndg gear collapsed & the acft veered off the rwy, further damaging the aircraft. An investigation revealed the left main landing gear trunnion had failed. It had failed diagonally aprx 5 inches from the bottom of the trunnion…Mar 11, 1988 · N1555X · Substantial damageNTSB ATL88FA109Accident · 2 fatalField investigationFinal reportCessna 150 · Sylva, NCThe pilot was conducting a local pleasure flight when the airplane was seen in the boxed canyon maneuvering. The witness said that the pilot was getting lower on each pass, until the airplane was about 300 feet above the ground when the airplane went into a…Mar 11, 1988 · N1258Q · DestroyedNTSB ANC88LA039Accident · No injuriesLimited investigationFinal reportCessna 207 · Ruby, AKThe aircraft was over the airport at 2,000 feet MSL when the engine quit. The aircraft crashed one mile north of the airport. Examination of the aircraft engine revealed a broken throttle control which would cause the engine to go to idle.Mar 11, 1988 · N70364 · Substantial damageNTSB SEA88LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Las Vegas, NVThe student pilot departed the airport for a cross country flight without filing a flight plan or obtaining a weather briefing. Upon returning to the originating airport he discovered that the winds were unfavorable for landing at that airport. The pilot then…Mar 10, 1988 · N98525 · Substantial damageNTSB SEA88LA055Accident · No injuriesLimited investigationFinal reportCessna 207A · Las Vegas, NVDuring a maintenance flight, while on final approach, the engine ceased operating. Adequate fuel was available in the right fuel tank. The left fuel tank contained 4.5 gallons of which 3.5 gallons are unusable. The plt said he was slipping the acft on the…Mar 10, 1988 · N6380H · Substantial damageNTSB LAX88LA123Accident · No injuriesLimited investigationFinal reportHelio HT-295 · Oracle, AZEngine failure for undetermined reasons.Mar 10, 1988 · N68871 · DestroyedNTSB CHI88LA076Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dixon, ILMar 10, 1988 · N4072D · Substantial damageNTSB CHI88FA075Accident · 3 fatalField investigationFinal reportBeech E18S · Warren, MIThe flt was an air taxi cargo flt carrying truck parts. After takeoff, the twr asked the plt if he was in difficulty and the plt replied 'roger' and requested a change of flt plan. The acft was seen flying erratically just above the tree tops. The acft…Mar 10, 1988 · N900WP · DestroyedNTSB CHI88DCA01Accident · No injuriesFinal reportBell 206B · Cahokia, ILThe instructor was giving a pilot an employment evaluation in the helicopter when during the startup the pilot prematurely added full power causing the helicopter to rotate rapidly to the right. The helicopter had been positioned on a trailer. During the…Mar 10, 1988 · N13Q · Substantial damageNTSB ATL88IA108Incident · No injuriesIncident investigationFinal reportBoeing 737 · Greensboro, NCContinental flt 458 (Boeing 737, N13331) was flying NE at FL370 as Continental flt 703 (Boeing 737, N432PE) was flying fm the opposite drctn at FL350. Both flts were on the same freq, being ctld by atlanta ARTCC (sector 47) ctlr, who had just come on duty. In…Mar 10, 1988 · N13331 · 2 aircraft · No damageNTSB ATL88IA107Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Atlanta, GAMar 10, 1988 · N310DA · Minor damageNTSB ANC88LA042Accident · No injuriesLimited investigationFinal reportCessna 185F · Ophir, AKDuring the takeoff roll from the frozen lake the pilot lost directional control of the aircraft causing the aircraft to nose over on its back. The pilot stated during the takeoff roll the aircraft crossed a snowmachine track causing him to lose control of the…Mar 10, 1988 · N5045R · Substantial damageNTSB ANC88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe private pilot-in-command of the Piper PA-18 lost control of the airplane while attempting to takeoff from a section of snow covered river ice.Mar 10, 1988 · N78AJ · Substantial damageNTSB ANC88FA037Accident · 1 fatalField investigationFinal reportBeech B35 · Nome, AKThe aircraft sustained an in-flight breakup during the enroute phase of the flight. The left fitting that secures the front spars of the stabilizers to the fuselage revealed the presence of pre-existing fatigue cracking. The initial separation of the left…Mar 10, 1988 · N5115C · DestroyedNTSB MIA88LA124Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Opa Locka, FLStudent pilot lost control of helicopter during aerial taxi. The helicopter made ground contact and entered into ground resonance. When the instructor attempted to regain control of the helicopter he found the student frozen on the controls preventing him…Mar 9, 1988 · N8755F · DestroyedNTSB DEN88LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COThe private plt was performing a night solo training flight in the local area. After several stop and go landings, the plt was returning to her home airport. At 6300FT MSL, in cruise flight, the plt reported that the engine quit. Attempts to restart were not…Mar 9, 1988 · N47567 · Substantial damageNTSB LAX88LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbia, CAAt the end of a pleasure flight, while on short final over the landing threshold, the left wing suddenly lifted. The pilot lost control of the aircraft which collided with the terrain and nosed over. There were no reported mechanical failures or malfunctions.Mar 8, 1988 · N8216E · Substantial damageNTSB LAX88DUG02Accident · Minor injuriesFinal reportPage Long EZ · Chino, CADuring a flight to test the effectiveness of the propeller, just after takeoff, one propeller blade separated from the hub. The pilot made an emergency off field landing in a soft field, where during the landing roll the aircraft collided with the terrain.…Mar 8, 1988 · N917WP · Substantial damageNTSB ANC88LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Big Lake, AKThe newly certificated private pilot was attempting to perform a soft-field, touch-and-go landing at an unimproved, off-airport site in deep snow. The airplane's main landing gear became mired in the snow, the nose wheel pitched down and the airplane…Mar 8, 1988 · N68945 · Substantial damageNTSB SEA88LA075Accident · No injuriesLimited investigationFinal reportPiper J-3 · Newberg, ORThe pilot had not flown for over five years and was doing multiple touch and goes in order to prepare for his biennial flight review. While on a landing rollout the engine ceased operating. The pilot exited the aircraft and began hand propping the engine. The…Mar 7, 1988 · N98028 · DestroyedNTSB NYC88LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Morristown, NJDuring a landing rollout, the flight encountered strong gusty crosswinds. The aircraft ran off the right side of the runway. The nose wheel dug into mud and the prop and left wing tip made contact with the ground.Mar 7, 1988 · N48900 · Substantial damageNTSB NYC88DGT01Accident · 1 fatalFinal reportNorth American F-51D · State College, PAN51WE, a North American F-51D took off as the second ship of a two ship flight with N6341T, another F-51D. They were observed climbing in formation into the clouds. N6341T assumed communications and said they were a flight of 2 and ok, after ATC was unable to…Mar 7, 1988 · N51WE · DestroyedNTSB MIA88LA121Accident · No injuriesLimited investigationFinal reportSchleicher K-8B · Miami, FLThe plt stated that he had placed the glider into a mild dive & was indicating 90 to 95 mph, well below redline speed when the whole section of the trailing edge of the wing from the aft spar & wing root out to a dist of about 6 ft, separated from the acft.…Mar 7, 1988 · N4663S · Substantial damageNTSB MIA88LA120Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hialeah, FLWhile attempting to land in a field the pilot misjudged the height of the grass. The front part of the skids became entangled in the 2 foot height grass and the aircraft nosed over. Instruction was not taking place, however, the second pilot had 75 hours in…Mar 7, 1988 · N90669 · Substantial damageNTSB LAX88LA121Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Shandon, CADuring the initial climb, at approximately 20 feet AGL, a gust of wind forced the aircraft off course, resulting in a collision with a shed near the private dirt strip. The pilot reported that there were no mechanical failures or malfunctions with the…Mar 7, 1988 · N91286 · Substantial damageNTSB CHI88IA074Incident · No injuriesIncident investigationFinal reportSwearingen SA226T · Chicago, ILThe TRACON supervisor failed to comply with the established visual minima criteria and his incorrect issuance of a visual approach to an arriving aircraft.Mar 7, 1988 · N600TA · 2 aircraft · No damageNTSB ATL88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Orangeburg, SCThe engine lost pwr as the airplane was returning from a fire-patrol flt. The plt made a forced ldg in a field where the airplane ran into soft dirt and nosed over. Post-crash exam of the acft revealed no evidence of any fuel ramaining in the fuel system. The…Mar 7, 1988 · N8994Y · Substantial damageNTSB NYC88LA103Accident · No injuriesLimited investigationFinal reportCessna 140 · Schroon Lake, NYDuring landing roll on a frozen lake, the left landing gear dug into a soft spot. The aircraft nosed over and was substantially damaged. In his recommendation for prevention of this acc, the plt said 'by not lndg on ice.'Mar 6, 1988 · N89431 · Substantial damageNTSB NYC88LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Newport, VTDuring landing roll out on a frozen lake. The nose wheel contacted a soft spot in the ice and flipped over.Mar 6, 1988 · N8428L · Substantial damageNTSB MKC88LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mound City, MOThe PIC, after an earlier lndg at tarkio, Missouri and an unsuccessful attempt to reach his fishing partner, flew his acft to and landed at st. joseph rosecrans arpt. After contacting his friend, and catching a few hours of sleep, the PIC made an early…Mar 6, 1988 · N7703J · Substantial damageNTSB FTW88FA077Accident · Minor injuriesField investigationFinal reportFairchild M-62C · Arlington, TXFailure of the number six cylinder and piston.Mar 6, 1988 · N63739 · Substantial damageNTSB CHI88DEP04Accident · No injuriesFinal reportCessna 172L · West Bend, WIAfter 30 minutes of local flight, on a dark night, the pilot increased the throttle setting after selecting approach flaps. There was no response from the engine. A forced landing was initiated and the aircraft collided with trees and terrain. A subsequent…Mar 6, 1988 · N7089Q · Substantial damageNTSB ATL88FA106Accident · 2 fatalField investigationFinal reportCessna 150 · Knoxville, TNThe Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…Mar 6, 1988 · N60371 · 2 aircraft · Minor damageNTSB CHI88DEM02Accident · No injuriesFinal reportGalloway XTC · Lowell, MIThe pilot of the homebuilt aircraft was attempting to perform some 'pattern flights' when, after turning on to the base leg of the traffic pattern, the engine seized. The pilot attempted to 'dead stick' the aircraft to the runway, but altitude and airspeed…Mar 5, 1988 · N3969C · Substantial damageNTSB ATL88LA105Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Lincolnton, NCJust after lift off for a LCL flt, the plt-in-cmd, who was in the right seat, noted the front edge of the nose baggage compt to 'pop open'. He assumed control of the acft and attempted to 'tear drop' a return to the opposite runway. During the maneuver, the…Mar 5, 1988 · N4329C · Substantial damage