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 CHI88LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172 · North Liberty, INWhile departing from a grass strip the pilot was unable to maintain a sufficient rate of climb and airspeed during the climbout. In an effort to regain airspeed, the pilot stated that he pushed the nose forward and the aircraft struck the ground in a nose…May 22, 1988 · N5848A · Substantial damageNTSB BFO88LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Annapolis, MDDuring the landing rollout the aircraft drifted to the left. The left main wheel departed the pavement and encountered soft terrain. The aircraft groundlooped and nosed over. The pilot did not file an accident report.May 22, 1988 · N3173C · Substantial damageNTSB ATL88LA181Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1A · Blue Ridge, GAThe plt reported that he encountered deteriorating wx conditions during the flt. He made a 180 degree turn and other course changes in an attempt to return to better wx, but was unable to maintain VFR flt. He subsequently elected to make a precautionary ldg…May 22, 1988 · N80582 · Substantial damageNTSB SEA88LA099Accident · No injuriesLimited investigationFinal reportBrown 1911 Bellanca · Carson City, NVThe purpose of the flight was to test a new type of propeller which had just been installed on the aircraft. The pilot noticed prior to rotation an increase in the RPM. At rotation the nose up pitch was excessive. The pilot lowered the nose of the aircraft to…May 21, 1988 · N10317 · Substantial damageNTSB NYC88LA162Accident · No injuriesLimited investigationFinal reportCessna 150 · Poland, NYStudent pilot stated that on his last takeoff after doing many practice touch and gos from his private strip at his farm, his stall warning came on. When he tried to push the yoke down (forward), it was jammed. He said a small twig had jammed the elevator. He…May 21, 1988 · N6078T · Substantial damageNTSB NYC88LA145Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Brookhaven, NYLoss of power due to carburetor ice during an attempted go around. Pilot landed in scrub pines and airplane nosed over.May 21, 1988 · N96193 · Substantial damageNTSB MKC88LA095Accident · No injuriesLimited investigationFinal reportBeech 23 · Independence, MOThe PIC planned a local flt to practice touch and go lndgs. On an earlier flt the PIC had switched the fuel selector to what he thought was the fullest tank. As the subsequent flt progressed, the PIC again selected what he considered to be the fullest tank as…May 21, 1988 · N2378L · Substantial damageNTSB MKC88LA094Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Cassville, MOThe PIC dptd Texas enr to bolivar, MO with a stop for fuel in pinebluff, ark with two revenue pax's aboard. The PIC stated that the pax would try to locate the arpt by visually identifying the lights of the city. The PIC stated they wandered to several…May 21, 1988 · N2585V · Substantial damageNTSB MIA88RA173Accident · No injuriesForeign investigationBell 222UT · Kingston, JamaicaMay 21, 1988 · H-18NTSB MIA88LA174Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Geneva, FLThe pilot state that he encountered turbulence over a tree line while on short final approach. The aircraft began to sink and before the sink rate could be arrested the aircraft struck a tree. The aircraft touched down short of the runway.May 21, 1988 · N45980 · Substantial damageNTSB LAX88LA193Accident · No injuriesLimited investigationFinal reportRobinson R22 · Paso Robles, CADuring a local introductory instructional flight, the student lost control of the helicopter. The flight instructor was unable to take control before the tail rotor contacted the ground. The helicopter collided with the terrain and rolled over.May 21, 1988 · N32Y · Substantial damageNTSB FTW88NA106Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-30 · Dfw Airport, TXMay 21, 1988 · N136AA · Substantial damageNTSB CHI88LA116Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · La Crosse, WIMay 21, 1988 · N9686S · Substantial damageNTSB ATL88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Shellman, GAThe plt was making a personal flt to a pvt uncharted airstrip on a coastal island. Approaching his destination, the plt cancelled his VFR flt plan with fss. The plt stated that he approached the soft 2500 foot strip high and ballooned at touchdown. He landed…May 21, 1988 · N8374U · Substantial damageNTSB ANC88FA062Accident · 1 fatalField investigationFinal reportDe Havilland DHC-2 · Anchorage, AKThe airplane had undergone extensive maintenance which included work on the control column. The upper half of the control column was replaced with a throw-over yoke and the aileron system was rerigged. The pilot-in-command picked up the airplane after it was…May 21, 1988 · N1435Z · DestroyedNTSB SEA88LA100Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Clementsville, IDThe pilot was using a road as his base of operations for an aerial applications operation. During takeoff the aircrafts' wingtip struck a moving automobile's windshield. The plt did not file an accident report.May 20, 1988 · N4842Y · Substantial damageNTSB SEA88LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ritzville, WAWhile on an aerial applications flight, the pilot was climbing to clear power lines when a whirlwind was encountered. The aircraft struck a power pole and descended onto the ground.May 20, 1988 · N6963K · DestroyedNTSB DEN88FA110Accident · 2 fatalField investigationFinal reportCessna 152 · Heber City, UTThe CFI and student plt were on a round-robin cross-country flt. A witness near the accident site said he saw an airplane flying 'up a canyon quite slow and low'. The airplane was reported overdue and found the next day in a 'box canyon' at the 8,500 foot…May 20, 1988 · N25934 · DestroyedNTSB CHI88LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Terre Haute, INMay 20, 1988 · N55786 · Substantial damageNTSB CHI88DET03Accident · No injuriesFinal reportDavis Heath Model V · Valparaiso, INThe plt rprtd that when he applied power to takeoff, the acft 'pulled to the right.' He said the acft became airborne, but touched down again & contd to go to the right. Also, he said he tried to correct the situation with left rudder, but the rudder seemed…May 20, 1988 · N312HD · Substantial damageNTSB ATL88LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe pilot was conducting a maintenance test flight when he experienced a drop in engine RPM. After a series of bangs the engine quit. The pilot made a forced landing into a rough field. The engine examination disclosed that no. 1 piston had failed. The engine…May 20, 1988 · N94533 · Substantial damageNTSB MKC88LA092Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Mc Dougal, ARThe pilot stated that he had just begun the spraying of a rice field when one of the spray nozzles malfunctioned. As he was attempting to set the helicopter down on the ground, to work on the nozzle, the main rotor blades struck a tree. The main rotor blades…May 19, 1988 · N4690 · Substantial damageNTSB LAX88LA191Accident · Serious injuriesLimited investigationFinal reportBeech G-35 · Bullhead City, AZMay 19, 1988 · N4472D · Substantial damageNTSB LAX88LA189Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Anderson, CAAfter receiving information of existing unfavorable wind conditions and that fuel was not available at the planned refueling point the pilot elected to continue the flight without refueling. As he descended on approaching his destination the engine failed due…May 19, 1988 · N573HA · Substantial damageNTSB LAX88FA190Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Green Valley, AZFailure of the student pilot to accomplish the proper stall recovery procedures allowing the stall to develop into a spin. Contributing to this accident was the lack of training in spin recovery.May 19, 1988 · N2326A · DestroyedNTSB FTW88LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Graham, TXThe student pilot was on a solo round-robin cross country training flight. He made a hard landing on the nose wheel that resulted in a propeller ground strike and damaged engine firewall. Gusty surface winds prevailed at the time of the accident.May 19, 1988 · N4659G · Substantial damageNTSB FTW88DRD04Accident · Minor injuriesFinal reportGrumman G-164A · Rayne, LAThe pilot had made seven previous takeoffs in that airplane, that day, on the same airstrip. On this one, the OAT was 93 degrees f. the elevation was 10 feet MSL and the density altitude was 2300 feet. The airplane was 388 pounds overweight and the CG was .5…May 19, 1988 · N8657H · Substantial damageNTSB ATL88LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Myrtle Beach, SCThe plt was practicing touch and go ldgs on rwy 23 when he lost control of the airplane just after takeoff when it encountered a gust of wind. The rt wing contacted the terrain adjacent to the runway and the airplane flipped over.May 19, 1988 · N39932 · Substantial damageNTSB ATL88LA177Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lebanon, OHThe plt was making an apch for a full stop ldg with a quartering right tailwind. He stated that he had been previously told to always land on rwy 27 and takeoff from runway 09 at this apt. Witnesses indicated that the airplane touched down about half way down…May 19, 1988 · N69161 · Substantial damageNTSB LAX88LA188Accident · No injuriesLimited investigationFinal reportCessna 180 · S. Lake Tahoe, CAThe pilot lost control and dragged a wing while taxiing. The pilot indicated that he had just completed an uneventful landing and was taxiing to parking. He also indicated that he was taxiing too fast when he turned off the runway and the wing dipped and…May 18, 1988 · N2969A · Substantial damageNTSB LAX88FA187Accident · 2 fatalField investigationFinal reportCessna 182A · Grand Canyon, AZPilots selection of an inappropriate cruise altitude which did not ensure adequte terrain clearance on the leg of the flight from page to Grand Canyon, Arizona. A factor in the accident was the pilot's flight schedule on the day of the accident which may have…May 18, 1988 · N4845D · DestroyedNTSB FTW88LA105Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Plano, TXThe student pilot was returning from practice in the local area and was attempting a landing with a left quartering headwind, with wind gusts. After touchdown, the airplane started to float and drifted to the left, off the runway. The pilot attempted a…May 18, 1988 · N4675G · Substantial damageNTSB FTW88FA104Accident · 2 fatalField investigationFinal reportCessna 172P · Le Flore, OKThe acft was being used to fly over a wooded area & spot cattle for psnl on the ground. After spotting cattle for about 2 hrs, the plt was flying at low alt when the acft suddenly rolled into a steep bank, then the nose dropped & the acft crashed in a steep…May 18, 1988 · N212FR · DestroyedNTSB FTW88FA103Accident · Serious injuriesField investigationFinal reportGlobe GC-1B · Powderly, TXThe airplane had not been flown for more than seven months. It did not have a current annual inspection. Witnesses said the pilot ran the engine and it ran rough. Then he washed the airplane, then refueled, drained the sumps and ran the engine again at the…May 18, 1988 · N78143 · DestroyedNTSB ATL88LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Florence, SCThe accident occurred as the student pilot was attempting to depart rwy 27. He reported that the airplane began to turn to the left as he initiated rotation. He was unable to correct the turn, and he attempted to abort the takeoff. The airplane veered off of…May 18, 1988 · N757VH · Substantial damageNTSB ATL88DMG06Accident · No injuriesFinal reportCessna 188 · Messic, NCDuring turnaround procedures, the airplane collided with trees and crashed. The pilot indicated that he had sprayed the field where the accident occurred many times during the past three years.May 18, 1988 · N8250G · DestroyedNTSB ANC88LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Port Heiden, AKThe pilot elected to abort the takeoff of a heavily loaded Piper from a soft strip. His decision was tardy and the airplane struck a cinder bank.May 18, 1988 · N8259V · Substantial damageNTSB ANC88LA060Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Asigiyukpak, AKDuring the approach to the beach area the pilot stalled the aircraft. The aircraft nosed over on its back during the landing.May 18, 1988 · N32CP · Substantial damageNTSB ANC88FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Skwentna, AKThe on-demand air taxi flight with the pilot and two passengers struck the rock face of a mountain at the 8600 foot level. According to witnesses at the time of the accident the weather conditions were poor and visibility was less than one-half mile. The…May 18, 1988 · N897P · DestroyedNTSB SEA88LA097Accident · Serious injuriesLimited investigationFinal reportHughes 369E · Chemult, ORThe pilot was attempting to takeoff with a density altitude of 6,300 feet. The aircraft was operated near its maximum gross weight limitation. 150 feet from the initial takeoff the helicopter rotor stirred up dust and debris from a road, causing the pilot to…May 17, 1988 · N5258C · Substantial damageNTSB MKC88LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Bayard, NEThe pilot stated that he started the trip, from new Mexico to north dakota, the evening prior to the accident. Because of poor weather, the pilot re-routed the flight through several alternate fuel and oil stops. The flight was en route to a planned fuel stop…May 17, 1988 · N4510C · Substantial damageNTSB MKC88LA090Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A2 · Horton, KSThe PIC was executing touch and go lndgs when he reportedly experienced a shift in wind conditions. The acft impacted the ground short of the rwy. He said that the wings suddenly lost lift resulting in a high descent rate. The PIC reported no mechanical flt…May 17, 1988 · N3502L · Substantial damageNTSB MKC88FA089Accident · 1 fatalField investigationFinal reportAero Commander 690A · Little Rock, ARThe plt had just rtrnd fm vacation in the Bahamas bfr starting a flt fm Little Rock to atlanta with an intermediate stopat memphis. This itinerary was flwd by a rtrn flt to Little Rock via a reverse routing. Witnesses rprtd the plt said he had only 2 hrs of…May 17, 1988 · N660RB · DestroyedNTSB DEN88FA109Accident · 5 fatalField investigationFinal reportCessna T210N · Albuquerque, NMMay 17, 1988 · N5402Y · DestroyedNTSB ANC88LA058Accident · No injuriesLimited investigationFinal reportCessna 185E · Tuntutuliak, AKThe private pilot-in-command of the Cessna 185 was performing business flying for the federal aviation administration. When he ran out of fuel during a cross country flight, he attempted an off-airport forced landing which resulted in a noseover accident. The…May 17, 1988 · N1592F · Substantial damageNTSB ANC88FA057Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Wasilla, AKThe private pilot and passenger were making an approach to the Wasilla airport, Wasilla, AK, when the engine lost power. The pilot made a sharp 180 degree turn to try and reach a paved street about 3/4 of a mile short of the runway. The airplane stalled and…May 17, 1988 · N7224K · Substantial damageNTSB ANC88DAG04Accident · No injuriesFinal reportPiper PA-18 · Togiak, AKDuring the takeoff from a beach, the aircraft hit a log causing substantial damage to the landing gear. The pilot stated that during the takeoff run he did not see the log. He then proceeded to an airport where during the landing roll the landing gear…May 17, 1988 · N842JT · Substantial damageNTSB NYC88IA141Incident · No injuriesIncident investigationFinal reportCessna S550 · Allentown, PAWhile cruising at FL350 in light turbulence, the trailing half of the left hand outboard trailing edge flap separated from the acft. The pilot declared and emergency and landed at poughkeepsie, new york, without further incident. The portion of the damaged…May 16, 1988 · N81SH · Minor damageNTSB MIA88WA172Accident · No injuriesForeign investigationCessna 402C · Mangrove Cay, BahamasMay 16, 1988 · C6503 · Substantial damageNTSB MIA88LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe plt stated that upon touchdown, the aircraft landed hard, bounced twice and ran off the side of the runway into the grass.May 16, 1988 · N734QP · Substantial damage