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 NYC88LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe aircraft was taxiing from a shop on the airport to runway 24 for a south end departure. The pilot stated that the left wing of the aircraft made contact with the parked truck causing substantial damage.Dec 24, 1987 · N32560 · Substantial damageNTSB MIA88FA071Accident · 1 fatalField investigationFinal reportCessna 150H · Destin, FLWitnesses stated that they observed the acft flying in the fog in a southeasterly direction and turn hard right just before it struck the 19th floor of a condominium. The fog according to residents of the bldg was so thick that the ground could not be seen…Dec 24, 1987 · N7005S · DestroyedNTSB LAX88LA077Accident · No injuriesLimited investigationFinal reportCessna 150E · Hilo, HIDuring a local pleasure flt, while climbing to 5500 feet, the engine sputtered and quit. During the landing roll, the acft nosed over. The engine was examined with no mechanical failures or malfunctions noted. The acft was operating in the range of serious…Dec 24, 1987 · N3009J · Substantial damageNTSB LAX88LA076Accident · No injuriesLimited investigationFinal reportCessna 210K · Chowchilla, CADuring a cross country flt, the plt had diverted to another arpt for fuel. The plt was unable to activate the rwy lights and a forced landing was made that was perpendicular to the rwy. Upon inspection of the acft, an incorrect frequency was noted on the…Dec 24, 1987 · N8221M · Substantial damageNTSB LAX88FA075Accident · 8 fatalField investigationFinal reportPiper PA-31-350 · Maunaloa, HIThe flight was to be flown across a 22 mile channel between islands on an overcast night with no moon and no ground reference lights. The aircraft disappeared from radar and, after extensive searches, could not be found. A three dimensional flight track was…Dec 24, 1987 · N712AN · DestroyedNTSB LAX88DUM02Accident · 1 fatalFinal reportBede BD-5 · Chula Vista, CADec 24, 1987 · N29DT · DestroyedNTSB ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…Dec 24, 1987 · N6571R · DestroyedNTSB MKC88FA032Accident · 2 fatalField investigationFinal reportCessna 402C · Chadron, NEThe acft was on a flt to Chadron via Chadron VOR. Abt 30 mi sse of the VOR, the plt reqd & was clrd to fly drct to ackmeiaf for an NDB rwy 2 apch. The acft contd twd the VOR which was in the same general drctn, but 11.9 mi south of ackme. The NDB was at the…Dec 23, 1987 · N105GP · DestroyedNTSB MIA88WA074Accident · No injuriesForeign investigationMitsubishi MU-2B-30 · San Salvador, El SalvadorDec 23, 1987 · N255C · Substantial damageNTSB MIA88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLU.S. Coast guard personnel stated that the pilot reported that they were out of fuel and were ditching approximately 110 miles southeast of Marathon FL. The pilots were picked up by the coast guard and were transported back to miami.Dec 23, 1987 · N5433Y · DestroyedNTSB FTW88LA041Accident · No injuriesLimited investigationFinal reportCessna 172XP · Godley, TXDuring a cross country flight, the weather worsened. Visibility decreased and the ceiling lowered, forcing the pilot to descend in order to remain VFR. The pilot elected to perform a precautionary landing in a field. During landing roll the pilot noticed a…Dec 23, 1987 · N736AN · Substantial damageNTSB DEN88LA040Accident · No injuriesLimited investigationFinal reportBeech A36 · Angel Fire, NMThe private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the…Dec 23, 1987 · N27LH · Substantial damageNTSB DCA88MA011Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kenai, AKThe pilot had just departed the runway when he reported to the flight service station that he had engine problems. The aircraft was observed by witnesses to be about 300 ft on a descending downwind. The pilot stated that he was circling for runway one.…Dec 23, 1987 · N496SC · DestroyedNTSB NYC88LA059Accident · 1 fatalLimited investigationFinal reportCessna 170A · Sandwich, MAThe Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…Dec 22, 1987 · N5571C · DestroyedNTSB LAX88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Los Angeles, CAWhile taxiing after landing, N911E was instructed to taxi to a position and hold, en route to that position, the acft collided with N75397 that was also holding in the same position. The plt of N911E stated that he did not see the acft due to moisture that…Dec 22, 1987 · N75397 · 2 aircraft · Substantial damageNTSB CHI88LA034Accident · No injuriesLimited investigationFinal reportCessna 172K · Staunton, ILDuring the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot…Dec 22, 1987 · N78705 · Substantial damageNTSB MKC88LA031Accident · No injuriesLimited investigationFinal reportSonerai 2L · St. Louis, MOWhile practicing take offs and ldgs, PIC lost directional control during rollout. He added power and struck a snowbank just after becoming airborne during running takeoff.Dec 21, 1987 · N502WM · Substantial damageNTSB MIA88LA073Accident · 1 fatalLimited investigationFinal reportCessna 152 · MissingAccording to the operator the acft departed san juan, PR on a cross country flight to la romana. The acft arrived there & dropped the student off & the plt departed at about 1400 ast on his return trip to san juan. The acft did not arrive at it's destination…Dec 21, 1987 · N757EQ · DestroyedNTSB MIA88IA068Incident · No injuriesIncident investigationFinal reportBeech 99 · Tampa, FLThe commuter air carrier crew received an unsafe nose gear indication on final approach. The approach was abandoned and all efforts to use the emergency extension procedures were to no avail. The crew secured both engines on final and landed nose gear up.…Dec 21, 1987 · N6724D · Minor damageNTSB LAX88LA073Accident · No injuriesLimited investigationFinal reportCessna 195A · Burbank, CAWhile holding short of the active rwy, the number one acft,N4309Y, was having radio problems. The tower began to clear other acft for takeoff. Two acft were able to get around the number one acft and takeoff. The third acft cleared to taxi into position did…Dec 21, 1987 · N4026A · 2 aircraft · Minor damageNTSB FTW88FA039Accident · 15 fatalField investigationFinal reportAerospatiale SA-330J · Eugene IslandThe helicopter, with 2 plts & 13 passengers, was on an IFR flt to a psn in the gulf of Mexico. From that psn, they proceeded under VFR to an off-shore oil drilling rig (EI-190). As the helicopter was arriving from the se, there was a strong wind from the NE.…Dec 21, 1987 · N3596N · DestroyedNTSB SEA88FA032Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Eastsound, WAThe plt depd south from an unattended island arpt at sea level & flew into marginal VFR conds with moderate snowfall. Acquaintances at the arpt rprtd the plt expressed an urgent need to return to snohomish, WA, despite the wx conds. When the acft did not…Dec 20, 1987 · N4306J · DestroyedNTSB LAX88LA072Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Fallbrook, CAThe plt stated that while on short final to rwy 36, approx 5 to 6 ft AGL ovr the rwy, he noticed another acft approaching fm the opposite direction. He initiated a climbing right turn and collided with a tree located abt 150 ft to the right of the rwy…Dec 20, 1987 · N7970B · DestroyedNTSB NYC88LA058Accident · No injuriesLimited investigationFinal reportCessna 182 · Hammonton, NJThe aircraft had taxied to the runup area and during this process of engine runup, the pilot stated that the engine was running rough on one magneto but smooth on the other. The carburetor mixture was leaned but the engine quit. When an attempt to restart was…Dec 19, 1987 · N3041Y · DestroyedNTSB MIA88LA065Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Guvate, PRThe private pilot became separated from the formation of 4 aircraft and entered an area of deteriorating weather. He descended and attempted to maintain visual contact with the ground and struck trees and crashed. The pilot was not instrument rated and did…Dec 19, 1987 · N5123G · DestroyedNTSB LAX88FA071Accident · 2 fatalField investigationFinal reportBeech A35 · Chino Hills, CAFailure of both pilots to see and avoid each other and thus avert the collision.Dec 19, 1987 · N675B · 2 aircraft · DestroyedNTSB FTW88FA038Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Burnet, TXThe pilot arrived in the area of his planned destination and completed the outbound and inbound procedure turns for the NDB runway 17 approach without reported incident. Almost immediately thereafter, the aircraft impacted a large oak tree about 15 feet AGL…Dec 19, 1987 · N33007 · DestroyedNTSB FTW88DRG04Accident · 1 fatalFinal reportMBB 109 · Harlingen, TXThe set of floats which allows a high fuel flow in this carburetor for high power settings used for takeoff, climb, etc., had cracked and swollen to such an extent that they were rubbing against the float chamber walls and float chamber shroud tubes. This…Dec 19, 1987 · N8575 · DestroyedNTSB DEN88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Las Cruces, NMWhile practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.…Dec 19, 1987 · N23497 · Substantial damageNTSB DEN88LA038Accident · No injuriesLimited investigationFinal reportCessna T210R · Bismarck, NDThe plt was attempting to takeoff at dusk on a gravel road. The acft veered off of road and hit a ditch.Dec 19, 1987 · N7381U · Substantial damageNTSB ANC88FA022Accident · Minor injuriesField investigationFinal reportCessna 208 · Bethel, AKThe plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial…Dec 19, 1987 · N9438F · Substantial damageNTSB MKC88LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · Siloam Springs, ARWhen the airplane was on downwind, the pilot thought he was pulling on the carburetor heat. The pilot attempted to apply power on final and found the engine was windmilling. The pilot found he had pulled the mixture instead of the carburetor heat. During the…Dec 18, 1987 · N23303 · Substantial damageNTSB MIA88LA067Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Marathon, FLWhile on a personal flt shortly after takeoff at an alt of aprx 400 ft, the plt reported that the eng quit shortly after she turned off the electric fuel pump. Attempts to restart were unsuccessful. A forced landing followed during which the acft collided…Dec 18, 1987 · CGRRP · Substantial damageNTSB MIA88LA066Accident · No injuriesLimited investigationFinal reportCessna A188B · South Bay, FLThe plt attempted a landing on a narrow runway, on an embankment. The airplane swerved to the left, into a crosswind, and left the rwy. The right main ldg gear collided with a boulder; the airplane nosed over and came to rest in the water.Dec 18, 1987 · N731LS · Substantial damageNTSB CHI88FA035Accident · 1 fatalField investigationFinal reportBeech 58 · Wedron, ILThe airplane struck trees and descended uncontrolled into a river while attempting a night forced landing after running out of fuel during a cargo flight. The airplane was found under water on the fifth day of a search conducted by the cap after two boys…Dec 18, 1987 · N3702K · DestroyedNTSB BFO88FA010Accident · Serious injuriesField investigationFinal reportSwearingen SA-226 · Chantilly, VAThe acft had descended through a cloud layer enroute for the scheduled lndg at iad and according to the crew had picked up some trace rime ice on its wing surfaces. Although pitot and sas (stall avoidance system) heat were used the captain elected not to use…Dec 18, 1987 · N23AZ · Substantial damageNTSB MIA88WA086Accident · No injuriesForeign investigationBoeing 747-124F · Bogota, ColombiaDec 17, 1987 · HK290 · Substantial damageNTSB FTW88LA040Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · Eldorado, TXWhile the pilot was attempting to land in a clearing, the main rotor blades contacted a tree causing the aircraft to descend uncontrolled for about 40 feet. The helicopter struck the ground in a nose low attitude causing damage to the skids, bubble, rotor…Dec 17, 1987 · N8945F · Substantial damageNTSB ATL88FA066Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Monroe, NCReptdly, the flt purpose was to administer a bfr to the plt/owner of the acft. The first takeoff was aborted. The acft deptd again without an apparent problem. After about 30 minutes, the apt mgr heard and saw the acft in a vertical descent and rotating about…Dec 17, 1987 · N9132H · DestroyedNTSB MKC88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osceola, ARThe airplane was being jump-started from an automobile. The flight instructor left for some equipment when the student called him back and said there was smoke in the cabin. The airplane started to burn and was demolished. The student stated there was a…Dec 16, 1987 · N1595J · DestroyedNTSB MKC88FA028Accident · No injuriesField investigationFinal reportAero Commander 680FL · Kansas City, MOAt 2108:57 ea flt 275(EA275) a Boeing 727, was cleared to takeoff on runway 19 and at 2110:24 N6509V, an Aero Commander,was cleared to taxi into position and hold. N6509V entered runway 19 near mid-field at taxiway A-3 without advising the tower of his intent…Dec 16, 1987 · N6509V · 2 aircraft · Substantial damageNTSB ATL88LA065Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Elizabethtown, KYAfter a short stop btn flts, the battery was too weak to crank the eng. The plt elected to hand-prop the eng while his non-rated pax held the brakes. He briefed the pax on the proper procedure. He had previously allowed the pax to operate the brakes while…Dec 16, 1987 · N7151L · Substantial damageNTSB SEA88FA031Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Lakeport, CAAlthough weather conditions were marginally VFR at his departure point, and the pilot had access to a vehicle which could have been used to drive to his dest, he departed novato, CA, enroute to Lakeport, CA, without obtaining a wx briefing nor filing a flt…Dec 15, 1987 · N400LA · DestroyedNTSB NYC88LA057Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Rome, NYThe flight was enroute from watertown to glens falls, new york when snow squalls of varying intensity and gusty wind conditions were encountered. The pilot stated that forward visibility was marginal. The engine failed shortly after changing heading towards…Dec 15, 1987 · N74085 · DestroyedNTSB MIA88LA064Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Marathon, FLWhile on a personal flt after the plt lowered the landing gear for landing, the left main landing gear did not extend. The plt continued the apch, & after touchdown, the acft veered off the rwy, collided with trees, then came to rest. According to FAA…Dec 15, 1987 · N707CC · Substantial damageNTSB DEN88FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Draper, UTDrg a ngt flt to reposition the acft to its home base, the eng lost pwr as the plt was cruising at about 1000' AGL. He transmitted a 'mayday' call & maneuvered the acft to make a forced lndg on an interstate hiway. While apchg to lnd, the acft struck the top…Dec 15, 1987 · N2138J · DestroyedNTSB MKC88FA027Accident · Serious injuriesField investigationFinal reportBritish Aerospace BAE-3101 · Joplin, MOThe capt stated that he had planned the approach at a higher-than-normal airspeed and altitude due to a reported low level windshear. At 400 feet AGL the acft entered a light downdraft but the crew corrected the descent profile with power. At 200 feet AGL the…Dec 14, 1987 · N331PX · DestroyedNTSB MIA88FA063Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Geneva, ALPrior to the acdnt, a witness saw the acft flying across an open field at a very low alt. Subsequently, it collided with the tops of several pine trees at about 90 to 95 ft AGL, then it crashed to the ground. No preimpact part failure or malfunction was…Dec 13, 1987 · N3512A · DestroyedNTSB ATL88LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Grantham, NCThe airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time.Dec 13, 1987 · N6258S · Substantial damageNTSB SEA88LA030Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Aurora, ORA single engine aircraft was taxiing from the south end of the ramp area to the runway. A twin engine aircraft entered the taxiway in front of the single engine aircraft from the right of the taxiway. The single engine aircraft struck the twin engine aircraft…Dec 12, 1987 · N3275P · 2 aircraft · Substantial damage