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 ATL88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cleveland, OHThe plt rptd that both engines began to surge shortly after t/o during climb. The engines subsequently lost pwr completely, and the plt made a forced ldg in trees. Post-crash exam revealed that the fuel selectors were in the inbd tank positions. The lt inbd…Mar 5, 1988 · N198CD · DestroyedNTSB ATL88FA104Accident · 2 fatalField investigationFinal reportBeech A36 · Bow, KYThe pilot had received two weather briefings. In both, he was advised of forecast and known icing conditions. The pilot reported ice build-up to ATC. Afterward he requested no further assistance from ATC to locate a suitable landing area. Wreckage examination…Mar 5, 1988 · N2929R · DestroyedNTSB MKC88FA059Accident · 2 fatalField investigationFinal reportBeech E18S · Vienna, MOThe plt rcvd a wx briefing bfr starting a ngt cargo opn in known icing conds. Bfr the flt, a line serviceman noticed ice on the acft's wings & suggested its removal, but the plt declined. Aprx 45 min after tkof, the plt rprtd to ARTCC that a de-ice boot had…Mar 4, 1988 · N45A · DestroyedNTSB MIA88LA203Accident · Serious injuriesLimited investigationFinal reportHunter Velocity · Merritt Island, FLWhile checking the stall characteristics of a homebuilt acft, the acft descended in a stalled condition until crashing into a river. The plt was unable to lower the nose. Investigation revealed that he improperly positioned baffles in the fuel tanks resulting…Mar 4, 1988 · N128JM · Substantial damageNTSB LAX88LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Hesperia, CAMar 4, 1988 · N2184U · Substantial damageNTSB ATL88LA100Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Norwalk, OHThe plt rptd that he was cruising at 9,000 ft when he observed the EGT gauge indication dropping. The engine began to run rough and he noticed a fuel odor in the cabin. The carb air temp gauge was indicating 'well out of' the icing range. He selected carb…Mar 4, 1988 · N84118 · Substantial damageNTSB ANC88LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe flight instructor was giving dual instruction to a student pilot on night landings. On the sixth touch-and-go landing, the instructor turned the landing light off for a no-light landing. The student landed the aircraft to the right of centerline, and…Mar 4, 1988 · N96082 · Substantial damageNTSB MIA88LA123Accident · No injuriesLimited investigationFinal reportHawker Siddeley HS-748 · St ThomasThe captain of air bvi flight BL-222 stated as they were waiting for clearance to taxi, they encountered the jet blast from American airlines flight 626 as it taxied from its gate. The rudder of the HS-748 was dmgd. The American airlines aircraft was unaware…Mar 3, 1988 · VPLVN · Substantial damageNTSB MIA88FA122Accident · No injuriesField investigationFinal reportBoeing 747-200 · Miami, FLAfter landing the Boeing 747-200 airliner, the captain increased the pitch attitude to 11 degrees nose up by pulling the control column aft. The tail struck the ground causing substantial damage. The Boeing airplane flight manual prescribes that the…Mar 3, 1988 · LVOOZ · Substantial damageNTSB FTW88LA076Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Midland, TXEncounter with severe turbulence within tops of convective clouds. Leading to this was the pilot's failure to properly evaluate the potential danger of the convective activity, which he chose to penetrate.Mar 3, 1988 · N8496P · Substantial damageNTSB CHI88LA072Accident · No injuriesLimited investigationFinal reportCessna P210 · Indianapolis, INWhile landing on the ice-covered runway, the pilot failed to stop his aircraft before the end of the runway. The aircraft ran off the departure end of the runway, encountered soft terrain and nosed over. The pilot had received two partial weather briefings,…Mar 3, 1988 · N4741K · Substantial damageNTSB ATL88IA102Incident · No injuriesIncident investigationFinal reportGovernment Aircraft Fact Nomad N22B · Birmingham, ALMar 3, 1988 · N422NE · Minor damageNTSB ANC88LA034Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Mcgrath, AKThe pilot had begun his descent for his destination airport 20 miles away when the engine lost all power. He was unable to restart the engine, and made a forced landing in deep snow. The pilot reported that he had been airborne for approximately two hours…Mar 3, 1988 · N1954U · Substantial damageNTSB SEA88FA054Accident · Minor injuriesField investigationFinal reportCessna T210N · Burns, ORThe aircraft engine quit during cruise flt on a bright moonlit night cross country flt at 8000 ft AGL, 28 NM west of Burns, OR. The pilot reversed course in an emergency descent and followed a straight 50 ft wide hwy toward Burns. At approx 500 ft. AGL the…Mar 2, 1988 · N5427A · DestroyedNTSB DEN88DTM01Accident · Serious injuriesFinal reportCessna 188 · Riverton, UTThis ag operator was fertilizing a field. He was making repetative trips which took about 10 min each. The plt was aware that the fuel gauges were inaccurate, reading less fuel than was actually onboard. While making a swath run the eng lost pwr and the acft…Mar 2, 1988 · N8073V · DestroyedNTSB CHI88LA071Accident · No injuriesLimited investigationFinal reportCessna 150M · Crane, INN66452, collided with a street signpost at the Crane naval depot, Crane, IN, during landing roll after a precautionary emergency landing. The right wing of the aircraft was substantially damaged. The student was on the return leg of a two-leg solo cross…Mar 2, 1988 · N66452 · Substantial damageNTSB BFO88FA025Accident · No injuriesField investigationFinal reportCessna 150E · Mitchellville, MDThe student plt elected to initiate the flt even though the flaps malfunctioned during the previous flt. Shortly after takeoff the plt was unable to keep the flaps in the extended position. The plt had not been feeling well on the morning of the flt and felt…Mar 2, 1988 · N6202T · Substantial damageNTSB ATL88LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe airplane encountered a crosswind gust at touchdown and the student plt lost control. The airplane veered off of the side of the rwy and subsequently impacted an embankment. The student had about 8 hrs of total solo flt experience, about 6 of which was…Mar 2, 1988 · N25265 · Substantial damageNTSB NYC88LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Maybrook, NYThe Piper PA-28 took off for a local pleasure flight. After takeoff the pilot noticed that the engine was running rough and he had lost his oil pressure. The engine seized and an off-airport landing was made in a snow covered field. Post-crash examination of…Mar 1, 1988 · N16255 · Substantial damageNTSB NYC88LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Southbridge, MADuring takeoff from Southbridge airport, the aircraft encountered a crosswind. The aircraft started drifting to the right even though full left aileron and full power were being applied. The pilot cut the power to abort the takeoff, and the aircraft impacted…Mar 1, 1988 · N75762 · Substantial damageNTSB MIA88IA119Incident · No injuriesIncident investigationFinal reportCessna 210M · Orlando, FLWhile on a positioning flt the acft landed gear up. The plt stated that he failed to follow the checklist & forgot to lower the landing gear. Examination of the landing gear assy by FAA personnel revealed no failure or malfunction.Mar 1, 1988 · N823AR · Minor damageNTSB ATL88DMG03Accident · Minor injuriesFinal reportThorp T-18 · Advance, NCMar 1, 1988 · N1369 · Substantial damageNTSB NYC88LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · West Dover, VTThe PA-28 landed short of the runway and struck a snowbank receiving substantial damage. The pilot when interviewed by the FAA said the engine did not miss and wasn't cutting out and that he would have to 'take the majority of the blame'. On NTSB form 6120.1,…Feb 29, 1988 · N83459 · Substantial damageNTSB MIA88LA118Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe plt stated that he was simulating a loss of power & then attempting to turn back to the arpt & land on the runway that they departed from. As he was turning back from an approximate altitude of 600 feet, the acft stalled & crashed.Feb 29, 1988 · N65532 · Substantial damageNTSB CHI88DEX02Accident · Serious injuriesFinal reportLogan Junior ACE · Cloverdale, INDuring approach, the aircraft struck power lines near the approach end of runway and crashed on the runway. The pilot had less than 1 hour flight time in this model homebuilt aircraft.Feb 29, 1988 · N21BL · Substantial damageNTSB NYC88LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Plymouth, MAThe pilot of the PA-24 said everything was normal until he switched fuel tanks and turned on the boost pump. He said a power loss followed. He was unable to get the engine restarted prior to making an off airport landing. A witness in the aircraft said the…Feb 28, 1988 · N5435P · DestroyedNTSB NYC88LA095Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Burlington, VTThe flight was taking off for an instructional flight in the local area. During ground run, the aircraft veered to the left and the pilot was unable to bring the aircraft under control. The aircraft collided with a snowbank and flipped inverted. The aircraft…Feb 28, 1988 · N97979 · Substantial damageNTSB NYC88DNA01Accident · No injuriesFinal reportGrosvenor Quickie · Middletown, RIThe worn propeller transmission (reduction gear assembly), which failed to transmit power to the propeller at a critical point in the go-around.Feb 28, 1988 · N3774X · Substantial damageNTSB MKC88FA058Accident · 4 fatalField investigationFinal reportCessna 172N · Oxford, IAWitnesses stated that the aircraft appeared to be in trouble immediatley after takeoff, as the wings were rapidly rocking while it was struggling to stay airborne. The aircraft turned sharply left, where it then barely cleared a row of trees. The airplane…Feb 28, 1988 · N5816E · DestroyedNTSB FTW88IA078Incident · No injuriesIncident investigationFinal reportCessna T210M · Grosebeck, TXThe pilot made a forced landing following engine failure. Teardown examination showed the no. 4 exhaust valve head had separated from the stem. Metal debris was found in the oil sump. The no. 1 connecting rod was separated from the crankshaft. There was…Feb 28, 1988 · N761RP · Minor damageNTSB FTW88FA072Accident · Minor injuriesField investigationFinal reportCessna P206D · Eagle Lake, TXAn inflight fire erupted following the separation of the number 4 cylinder. A metallurgist determined that studs failed in fatigue. The aircraft continued to burn after the emergency landing and was completely destroyed. The acft had an annual inspection…Feb 28, 1988 · N8721Z · DestroyedNTSB DEN88LA081Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Los Lunas, NMFeb 28, 1988 · N81DS · Substantial damageNTSB BFO88FID01Accident · 2 fatalFinal reportPerkins Christen Eagle II · Williamsburg, VAWitnesses saw the acft performing aerobatics which included loops and rolls. The acft was climbing in a loop when it suddenly pitched down and descended to the ground. Some witnesses said the acft was spinning as it descended.Feb 28, 1988 · N115MC · DestroyedNTSB ANC88LA033Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mekoryuk, AKThe pilot stated that during the touchdown the aircraft struck a snowbank on the approach end of the runway. The aircraft exited the right side of the runway approximately 500 feet from the approach end.Feb 28, 1988 · N7745Q · Substantial damageNTSB SEA88LA053Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Othello, WAThe student pilot encountered gusting winds and lost control of the aircraft during landing roll. The aircraft veered to the right of the runway and struck a parked unoccupied aircraft.Feb 27, 1988 · N5135T · Substantial damageNTSB NYC88LA097Accident · No injuriesLimited investigationFinal reportBeech 1900 · Albany, NYThe Beech 1900 was taxiing out at night under the control of a ground taxi director and two wing walkers when its tail made contact with the tail of parked and unoccupied B-737. Both pilots said they did not see a stop signal from the taxi director. The wing…Feb 27, 1988 · N7243R · Substantial damageNTSB MKC88LA057Accident · No injuriesLimited investigationFinal reportMorane-Saulnier F1-156C · Pine Bluff, ARThe pilot, while hand-propping the acft for a personal flt, started the engine. The cockpit was unattended. He was assisted by two ground crewmembers that were holding onto the wing struts. After starting, the engine progressively developed more power, and…Feb 27, 1988 · N44FS · Substantial damageNTSB MIA88LA117Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lantana, FLThe plt stated that he turned a long final apch due to other traffic in the pattern. He only saw one other acft in front of him. He was approximately 200 feet from the end of the runway when he felt the impact as the two acft collided. He then attempted to go…Feb 27, 1988 · N66661 · 2 aircraft · Substantial damageNTSB LAX88FA118Accident · 2 fatalField investigationFinal reportGrumman AA-5B · Frazier Park, CAImproper maintenance performed previous to the accident flight which failed to identify a fault which rendered the airplane nonairworthy. Contributing to this accident was the pilot's exercise of poor judgement in disregarding weather forecasts indicating…Feb 27, 1988 · N74236 · DestroyedNTSB LAX88FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28R-180 · Soledad, CAPilot's failure to promptly initiate remedial action and his failure to raise the aircraft's landing gear during an attempted go-around. Contributing factors relate to the pilot's poor in-flight decision, inattentiveness to VFR procedures and his not…Feb 27, 1988 · N7660J · Substantial damageNTSB LAX88DVA01Accident · Minor injuriesFinal reportEagle DW-1 · Modesto, CAWhile enroute for the purpose of spraying a field, the engine seemed to overspeed then lose power. The aircraft was landed on a soft field where during the landing roll, the aircraft nosed over. The propeller dome was found to have separated from the aircraft…Feb 27, 1988 · N8801Y · DestroyedNTSB FTW88LA073Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Decatur, TXThe non-certificated pilot flew the helicopter from his ranch to Decatur for refueling. After landing, he realized that he was too FAR from the fuel pump. Upon liftoff to move closer to the pump the helicopter rolled over. The pilot attributed the accident to…Feb 27, 1988 · N2233U · Substantial damageNTSB FTW88FA074Accident · 1 fatalField investigationFinal reportCessna 150J · Henderson, TXThe Cessna had just rolled out on base on 3rd or 4th touch go when it collided with a biplane that was not in the traffic pattern. Collision occurred between the outer panel of the left upper wing of the biplane and the rt side of the eng cowling of the…Feb 27, 1988 · N5522G · 2 aircraft · Substantial damageNTSB FTW88DRA04Accident · Serious injuriesFinal reportBarnett Drifter XP503 · Alvin, TXThe pilot reassembled the flight controls just prior to flight, and installed the aileron pins to connect the cables, but forget the safety locking devices. During flight, the pins fell out causing a total loss of aileron control.Feb 27, 1988 · N247JB · Substantial damageNTSB NYC88LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · North Hanover, NJThe eng lost power while the acft was circling at aprx 1500 ft AGL & the occupants were engaged in aerial photography. Subsequently, the acft was damaged during an emergency landing in a swampy area. An exam of the acft revealed the left tank was empty. The…Feb 26, 1988 · N738MX · Substantial damageNTSB MKC88LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Manhattan, KSWhile practicing short field ldgs at night, the pilot stated he felt he stalled on final about 15 to 20 feet above the runway. The aircraft bounced three times, striking each wing on the first two touchdowns and collapsing the nose gear assembly on the last…Feb 26, 1988 · N8850G · Substantial damageNTSB MIA88LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Saba Island, NTThe loss of power for undetermined reasons.Feb 26, 1988 · N419PH · DestroyedNTSB FTW88DRG07Accident · No injuriesFinal reportGrumman G-164A · Alamo, TXThe pilot experienced a total loss of engine power during climb when he made his initial power reduction. The power loss was accompanied by a loud bang. A severe postaccident ground fire melted a large portion of the engine. A partial engine teardown was…Feb 26, 1988 · N4647 · DestroyedNTSB CHI88LA070Accident · No injuriesLimited investigationFinal reportCessna 172A · Crivitz, WIThe aircraft did not accelerate as anticipated by the pilot, who was attempting to takeoff from a wet sod strip. The pilot elected to abort the takeoff, however was unable to stop on the remaining runway, exited the departure end, struck a snow bank and nosed…Feb 26, 1988 · N9751T · Substantial damageNTSB CHI88DER02Accident · 2 fatalFinal reportBellanca 7GCBC · Warroad, MNThe aircraft experienced a loss of control and rapid descent onto the ice in what witnesses described as a spin type maneuver from a low altitude. The purpose of the flight was a low level photo mission. The aircraft was destroyed. The pilot and passenger…Feb 26, 1988 · N53808 · Destroyed