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 FTW88LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Washington, OKThe student pilot received dual instruction in crosswind takeoffs and landings after which the instructor pilot deplaned to observe the student. The student lost directional control on the first takeoff attempt and the aircraft collided with a ditch after…Feb 19, 1988 · N9331T · Substantial damageNTSB FTW88FA066Accident · 3 fatalField investigationFinal reportAero Commander 680 · El Paso, TXThe non-instrument rated, non multiengine rated pilot, whose medical had expired, lost control of the aircraft during an IFR flight in instrument meteorological conditions. The aircraft crashed and burned. The pilot was attempting to return and land after he…Feb 19, 1988 · N634SA · DestroyedNTSB FTW88FA063Accident · 2 fatalField investigationFinal reportBeech S35 · Lake Charles, LAAcft crashed into a lake shortly after being vectored onto the final approach course for an ILS at 1,500'. Two current IFR plts were on board. Wx at the time was 500' ovc with 10 miles vis and no convective activity or turbulence reported in the area. No…Feb 19, 1988 · N5701K · DestroyedNTSB CHI88IA073Incident · No injuriesIncident investigationFinal reportBoeing 747-227B · Chicago, ILFailure of the tower cab supervisor to assure that coordination between the south local controller and north local controller had been completed. A factor is the failure of FAA tower management to insure there were personnel manning the cab coordinator…Feb 19, 1988 · N635US · 2 aircraft · No damageNTSB SEA88FA050Accident · Serious injuriesField investigationFinal reportBell 206A · Roseburg, ORWhile hovering at 200' AGL, the eng lost power & the plt entered an autorotation. He maneuvered to avoid trees & landed amid tree stumps in a logging clear cut area. An investigation revealed the 1st stage turbine wheel had failed. The wheel exited the eng &…Feb 18, 1988 · N7981J · Substantial damageNTSB NYC88LA090Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Oswego, NYDuring a local pleasure flight, a decrease in engine power was experienced and a puff of smoke observed in the cockpit. The pilot applied full power in an attempt to return to the airport, but realized it was not possible. The pilot put the aircraft down in…Feb 18, 1988 · N6939M · Substantial damageNTSB NYC88LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, NHThe student pilot was attempting a landing at Concord municipal airport. The aircraft touched down hard, bounced and at this time the pilot applied full throttle in an attempt to abort the landing and go around. However the aircraft veered left and struck…Feb 18, 1988 · N6341H · Substantial damageNTSB MIA88WA110Accident · No injuriesForeign investigationCessna 401B · Bimini, BahamasFeb 18, 1988 · N100PB · Substantial damageNTSB LAX88DUJ03Accident · No injuriesFinal reportBeech F33A · Goodyear, AZDuring an instructional flight, after takeoff, at 300 feet, the pilot and student said they heard a loud bang. The engine experienced a loss of power and the pilot noted that the top of the engine cowling was gone. A forced landing was made off the runway.…Feb 18, 1988 · N6785Y · Substantial damageNTSB DEN88LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Hurricane, UTThe student plt said that when he departed st. george, UT for Hurricane, which is 21 NM northeast, the wind was from the south at about 5 KTS. He landed to the north at Hurricane. He said he did not notice any wind as he prepared to depart to the south. Upon…Feb 18, 1988 · N67515 · Substantial damageNTSB CHI88DEE02Accident · 1 fatalFinal reportHill Bushby Mustang II · Yorkville, ILPerformance of aerobatic maneuvers with insufficient altitude for recovery.Feb 18, 1988 · N84HM · DestroyedNTSB ATL88LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Galion, OHThe airplane bounced during ldg, and subsequently ran off the side of the rwy into snow and nosed over. The wind conditions at the time were reportedly calm. The airplane was equipped with stc-approved conventional (taildragger) ldg gear. The plt stated he…Feb 18, 1988 · N4305A · Substantial damageNTSB MIA88LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLWhile on a personal flt, the passenger requested the instructor plt to demonstrate a forced landing. The plt descended, set up for a normal landing, & when the acft was at an alt of aprx 50- 100 ft, discontinued the descent & added power for climbout. At that…Feb 17, 1988 · N93137 · Substantial damageNTSB MIA88FA107Accident · 2 fatalField investigationFinal reportBeech 58P · Dunedin, FLFlt was being vectored for practice ILS approach in VFR conditions while the plt-in-command was receiving a biennial flt review. Radar data showed the acft constantly veering to the left off assigned heading and witnesses reported only hearing one engine…Feb 17, 1988 · N444MB · DestroyedNTSB FTW88DRG05Accident · No injuriesFinal reportAir Tractor 301 · Circleville, TXThe airplane was being ferried to a new location, and an en route refueling stop was planned. A low ceiling and low visibility set in and the pilot tried to extend the flight to a different town. The fuel was exhausted 6 miles short of a town. The airplane…Feb 17, 1988 · N3164Y · Substantial damageNTSB FTW88DRA03Accident · Serious injuriesFinal reportHiller UH-12-D · Bon-Wier, TXGround crewmember's failure to follow established procedures for secureing the aircraft to the transport trailer.Feb 17, 1988 · N48265 · DestroyedNTSB DEN88IA072Incident · No injuriesIncident investigationFinal reportDe Havilland DH-7 · Denver, COAs rocky mtn airway flt 2129 (De Havilland DH-7, N9058P) & Cessna 441, N1WB, were arriving, there was moderate to hvy traffic & a rwy change was in progress. N1WB & flt 2129 were provided initial sequencing by feeder ctlrs (AR-1 & AR-4). Both flts were handed…Feb 17, 1988 · N9058P · 2 aircraft · No damageNTSB BFO88LA021Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Orange, VAAccording to the plt, during the landing roll the acft drifted to the right and before he could take corrective action the acft ground looped. He had 3 hrs of total time in this make/model acft. The plt rptd he was late applying corrective rudder forces. He…Feb 17, 1988 · N2300N · Substantial damageNTSB BFO88FA022Accident · 1 fatalField investigationFinal reportCessna 150M · So. Charleston, WVThe stu plt said the engine began to alternate between partial and full power during the initial tkf climb. The acft was about 100 ft AGL and about 300 ft past the rwy end. According to the stu the inst took control of the acft, turned left, reversed course…Feb 17, 1988 · N9399U · DestroyedNTSB ATL88LA093Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Spartanburg, SCWhen the pilot was unable to find assistance to remove the nose wheel chock from the aircraft, he applied enough power to jump the chock. He was unable to retard the throttle before colliding with a parked aircraft and striking a concrete wall.Feb 17, 1988 · N3631H · Substantial damageNTSB ATL88LA091Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gainesville, GAThe plt rptd that he inadvertently allowed the airplane to descend below the VASI glidepath while on short-final, and that he failed to react in time to correct the situation. The airplane subsequently impacted an embankment short of the rwy threshold, in a…Feb 17, 1988 · N9265T · Substantial damageNTSB NYC88LA083Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Waterfall, PAShortly after takeoff, the pilot heard a loud 'boom' and experienced a loss of tail rotor control accompanied by an increase in N2 and RPM. A radio transmission was made to the aircraft that was trailing and then an approach for landing set up. On landing,…Feb 16, 1988 · N5093Y · DestroyedNTSB NYC88LA082Accident · No injuriesLimited investigationFinal reportGulfstream AA-5B · Bridgeport, CTDuring a touch and go landing, the aircraft touched down on the main gear just past the numbers. Full right aileron and left rudder was used for directional control. During rollout, the right wing came up and the left wing made contact with the runway…Feb 16, 1988 · N26834 · DestroyedNTSB MKC88LA053Accident · No injuriesLimited investigationFinal reportBeech 23 · Grain Valley, MOWhile practicing soft field takeoffs, the student pilot stated that he overrotated, establishing too high a nose up attitude. The aircraft entered a departure stall, followed by uncontrolled descent to the terrain.Feb 16, 1988 · N18868 · Substantial damageNTSB CHI88LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Martinsville, INWhile engaged in intentional low level flight for the purpose of doing advertising photography, the helicopter experienced a wire strike. The wire wound around the main rotor and pulled the helicopter to the ground. The helicopter received substantial damage.…Feb 16, 1988 · N21197 · Substantial damageNTSB BFO88LA019Accident · No injuriesLimited investigationFinal reportBeech C-23 · Roanoke, VAThis was the stu plt fifth training session where he did solo touch & go landings. During this session he made ten landings without incident. Six landings were made with his instr aboard followed by four solo landings. According to the stu during the flare…Feb 15, 1988 · N6634R · Substantial damageNTSB ATL88LA090Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Birmingham, ALThe airplane collided with trees on a hill at night, while on final approach. The plt rptd that he 'evidently got too low' on the approach. The visibility was 10 miles. The hilly terrain in the vicinity of the accident site was undeveloped, and had no…Feb 15, 1988 · N7448V · Substantial damageNTSB ANC88LA031Accident · No injuriesLimited investigationFinal reportCessna 170 · Healy, AKThe pilot stated that he was taxiing for takeoff when he lost directional control of the aircraft causing the plane to strike a small tree next to a snow covered taxiway.Feb 15, 1988 · N2601D · Substantial damageNTSB SEA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Stevens Pass, WAPlanned flt was VFR transit of cascade mountains in daylight. Plt filed VFR flt plan; wx brief indicated VFR. Unforeseen delays resulted in arrival at planned mountain Pass over one hour late and wx no longer VMC. Plt could see alternate Pass to north…Feb 14, 1988 · N6642E · Substantial damageNTSB SEA88LA046Accident · 2 fatalLimited investigationFinal reportCessna 305A (L-19) · Jean, NVWitnesses observed acft enter 45 deg climb attitude on liftoff, climb to about 200 ft AGL, then enter left turn. Acft appeared to stall, wing dropped and nose fell through to impact 100 yds left of runway. Flaps found set at 60 deg vs. max 30 deg setting…Feb 14, 1988 · N5173G · DestroyedNTSB MIA88LA106Accident · Serious injuriesLimited investigationFinal reportWaco UPF-7 · St Petersburg, FLThe plt stated that while on apch to land, the engine lost power. During an attempt to land on runway 36 the acft stalled & nosed in from an approximate 50 foot altitude. No determination could be made as to the nature of the malfunction of the engine as…Feb 14, 1988 · N29368 · Substantial damageNTSB FTW88LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Maud, TXThe acft took off from a 1800 ft private, turf, strip. The takeoff was to the sw and the wind was strong and gusty from the nw. There are trees along the right or upwind side of the rwy. Shortly after takeoff, the acft encountered turbulence and collided with…Feb 14, 1988 · N9319T · DestroyedNTSB FTW88LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Crowley, TXThe engine stopped as a result of fuel starvation, due to a large amount of contamination throughout the fuel system. The source of the contamination and the length of time it had been in the system was not determined. The pilot was not in gliding distance of…Feb 14, 1988 · N3180B · Substantial damageNTSB DEN88LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Aurora, COFeb 14, 1988 · N9419C · Substantial damageNTSB DEN88LA070Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Circle, MTPlt and passenger were hunting coyotes from the air. Upon landing to pick up a coyote they had shot, the acft encountered deep snow and nosed over.Feb 14, 1988 · N55PA · Substantial damageNTSB CHI88LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Ft. Wayne, INAirplane nosed over in soft snow during a crosswind landing attempt. The PIC tried to recover from a loss of directional control by attempting to roll out on snow covered sod after hopping over a snowbank that was next to the runway landing surface.Feb 14, 1988 · N5499K · Substantial damageNTSB ATL88LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Wakeman, OHThe 106 hour pvt plt reptd that he had rented the acft for a LCL flt from the uncontrolled airport. The rwy was snow and ice covered with a 12 kt wind from 240 degrees. After conferring with the LCL CFI on duty, he elected to make the LCL flt. During the t.o.…Feb 14, 1988 · N633BC · Substantial damageNTSB SEA88LA049Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Lovelock, NVThe non-multiengine rated pilot (left seat) executed a takeoff during which the aircraft developed a slight right drift. The pilot then attempted to utilize nose wheel steering to correct and a hard left swerve ensued resulting in a loss of directional…Feb 13, 1988 · N68915 · Substantial damageNTSB SEA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAPlt was following taxi line and failed to note parked acft left wing intruding into taxi lane. Contact between left wing tips resulted.Feb 13, 1988 · N52794 · Substantial damageNTSB LAX88LA110Accident · 2 fatalLimited investigationFinal reportCessna 152 · Seneca, AZFeb 13, 1988 · N757NM · DestroyedNTSB LAX88LA109Accident · No injuriesLimited investigationFinal reportCessna 185E · Redding, CAThe canadian plt attempted to land the conventional gear acft on runway 34 with the reported local wind from 330 deg at 16 KTS. The acft touched down about 2400 ft beyond the threshold of the 7003-foot-long rwy. After a bounced landing, directional control…Feb 13, 1988 · CFCTO · Substantial damageNTSB DEN88GA068Accident · 1 fatalFinal reportCessna T-337H · Galisteo, NMFeb 13, 1988 · N602SP · DestroyedNTSB CHI88LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIWhile taxiing for takeoff the aircraft experienced a nose over when it contacted a snowbank. The instructor stated that she allowed the student pilot to taxi too fast and was unable to take control of the aircraft soon enough to avoid hitting the snowbank.Feb 13, 1988 · N49540 · Substantial damageNTSB ANC88LA029Accident · No injuriesLimited investigationFinal reportCessna 180 · 70 Nw Anchorage, AKThe pilot stated that during the landing roll on the frozen lake he lost directional control of the aircraft due to the snow on the lake. The aircraft then nosed over on its back.Feb 13, 1988 · N674M · Substantial damageNTSB NYC88LA085Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Philadelphia, PAThe Mitsubishi MU-2B-35 landed and damage was observed on the underside of the left wing midway between the engine and tip tank and outboard to the tip tank. Further examination of the wing showed a broken lower front wing spar and a bent rear lower wing…Feb 12, 1988 · N339MA · Substantial damageNTSB NYC88LA081Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Chatham, MAAfter aborting two landings on runway 24 at Chatham, Massachusetts, the pilot was advised by radio to use runway 6. While attempting a landing on runway 6, the airplane touched down short of the runway and the landing gear was sheared off when it struck a…Feb 12, 1988 · N9281P · Substantial damageNTSB MIA88FA105Accident · 1 fatalField investigationFinal reportCessna 425 · Sanford, FLThe flt was cleared for a night ILS apch & advised that twr at dest had closed. Twr had rptd at closing that fog was forming & the flt was advised of the fog. The acft was located on a remote part of the arpt the next morning. The ELT had activated but the…Feb 12, 1988 · N6771Y · DestroyedNTSB LAX88FA108Accident · No injuriesField investigationFinal reportRobinson R-22B · Westlake Vlg, CAPilot's remedial actoin after encountering a pitch up wass too abrupt and the improper use of the cyclic control.Feb 12, 1988 · N2445Q · Substantial damageNTSB FTW88LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilots experienced a sudden total and complete loss of engine power during climbout after takeoff. Suitable terrain for a safe landing was not available and the aircraft was damaged during landing on a golf course. Examinations of the aircraft and engine…Feb 12, 1988 · N669ST · Substantial damageNTSB FTW88FA064Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Laplace, LAPlt was in level crz flt at night when he observed sparks and flame coming from the eng cowling. Shortly thereafter, the eng began running rough and then seized. After declaring an emergency and being cleared straight in to a runway about 28 miles away, the…Feb 12, 1988 · N4882S · Substantial damage