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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB MIA88RA173Accident · No injuriesForeign investigationBell 222UT · Kingston, JamaicaNTSB 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.NTSB 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.NTSB FTW88NA106Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-30 · Dfw Airport, TXNTSB CHI88LA116Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · La Crosse, WINTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB CHI88LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Terre Haute, INNTSB 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…NTSB 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…NTSB 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…NTSB LAX88LA191Accident · Serious injuriesLimited investigationFinal reportBeech G-35 · Bullhead City, AZNTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB DEN88FA109Accident · 5 fatalField investigationFinal reportCessna T210N · Albuquerque, NMNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB MIA88WA172Accident · No injuriesForeign investigationCessna 402C · Mangrove Cay, BahamasNTSB 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.