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 DEN85LA047Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Taylor, UTAcft collided with a pile of snow near the edge of rwy while landing. Plt stated he misjudged the apch and reduced power prematurely.NTSB CHI85LA081Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wisconsin Rapid, WIThe plt stated that during takeoff into winds form 290 deg at 10 KTS gusting to 15 KTS, the acft began to slide to the left on the icy rwy. When the acft hit a snow bank along the rwy, the nose gear collapsed.NTSB CHI85LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Staunton, ILWhile taxiing for takeoff at a private airstrip, the acft contacted a parked truck. The plt attributed the collision to his lack of alertness.NTSB ATL85LA063Accident · No injuriesLimited investigationFinal reportCessna 150G · Rockingham, NCWhile on x-country flt, plt was unable to obtain fuel at en route aprt. Plt filed new flt plan to alternate fuel stop. On arrival, plt decided he had sufficient fuel to fly on to arpt nearer destination and overflew planned stop. Shortly thereafter, due to…NTSB SEA85LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Coeur D' Alene, IDOn takeoff run, acft drifted left of center line, left seat pilot made corrective rudder input then right seat pilot made additional corrective input. Acft yawed moderately to left and contacted a snow berm. Acft spun left 180 degrees and slid backward to a…NTSB NYC85LA046Accident · No injuriesLimited investigationFinal reportCessna 140 · Burlington, VTThe acft skidded & veered left during the landing roll, & subsequently, it nosed over on the rwy.NTSB MKC85FPG01Accident · Serious injuriesFinal reportPiper PA-28-151 · Pine Bluff, ARWhile on a x-country personal flight, the plt became disoriented near Pine Bluff, AR. He flew for several minutes before contacting air traffic control for assistance. While being vectured to the Pine Bluff airport by ATC, the acft ran out of fuel and…NTSB MKC85FA037Accident · 1 fatalField investigationFinal reportAero Commander 690A · Pea Ridge, ARPlt was cleared for vor/dme approach to rogers arpt by fayetteville apch control; fayetteville altimeter setting of 29.85 (confirmed by recorded transcript) furnished. Plt did not read back. During apch, acft impacted trees 25 ft AGL at aprx 1320 ft MSL, 3…NTSB MIA85LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hollywood, FLThe eng lost pwer at aprx 400 ft AGL in a left climbing turn after takeoff from rwy 09L. The plt continued the left turn in an effort to land on rwy 18L. Easterly winds caused the acft to overshoot and land on grass on the west side of the arpt. During the…NTSB FTW85LA082Accident · Serious injuriesLimited investigationFinal reportFairchild M-62A · San Antonio, TXA total pwr loss was experienced while manuevering over an airport at about 250 ft AGL. The acft collided with rough terrain during the forced landing. Visual inspection of the acft fuel system indicated that the pwr loss was due to fuel exhaustion.NTSB CHI85IA073Incident · No injuriesIncident investigationFinal reportBeech 58P · Akron, OHDuring arrival at medina, OH, the plt discovered that the NDB was inop, so he diverted to the Akron fulton arpt. He was vectored for a localizer apch to rwy 25. During the apch, he descended to the min descent alt (mda) of 512 ft AGL. When he had the arpt in…NTSB ATL85LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Tuxedo, NCThe recently certified private plt was under a VFR flt plan and continued the flt into known adverse wx conditions. While attempting to maneuver the acft out of the low ceiling, it was flown into the high terrain.NTSB MKC85FA036Accident · 1 fatalField investigationFinal reportCessna 310L · Kaiser, MOThe acft was observed departing the airport to the south climbing. IFR flt conditions prevailed in the area. The plt rptd VFR at 2000 ft. the acft was noted by passengers of an earlier flight to have malfunctioning autopilot altitude andguidance…NTSB LAX85LA061Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Garberville, CAThe plt reported that on his first attempt to land he was 'too high' so he made a go-around. On the second apch to the 3050 ft rwy, he was flying at 110 mph. He landed long, applied brakes & skidded off the dept end of the rwy. The lt tire blew-out,…NTSB LAX85FA078Accident · Serious injuriesField investigationFinal reportGrumman AA-5B · Corona, CADuring maint of the eng, & just before the annual inspection was signed off, someone partially loosened & then attempted to tighten the bolt securing the crankshaft gear to the crankshaft. The old lockplate was not replaced & was not properly secured about…NTSB FTW85FA081Accident · 1 fatalField investigationFinal reportGates Learjet 35 · Waco, TXNo evidence of preimpact mechanical failure or malfunction was noted during wreckage examination. The FAA operations inspector who was on board at the time of the accident stated there were no aircraft problems involved. The PIC, who wasin the process of…NTSB BFO85IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · New Orleans, LADuring arrival, a Boeing 747, registration number d-abyp, lufthansa flight 5432, was vectored for an ILS localizer backcourse apch to rwy 19 at the new orlean intl arpt. While on the apch at 2000 ft MSL, the aircrew were instructed by the arrival controller…NTSB ATL85FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glasgow, KYThe acft crashed one mi short of rwy 07 at Glasgow municipal airport while on sdf rwy 07 inst app. There were no witnesses to the actual accident other then the surviving passenger who stated that the plt had asked her to look for the rwy lights. She stated…NTSB ATL85FA060Accident · 1 fatalField investigationFinal reportCessna 172 · Hamilton, ALInitiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…NTSB SEA85LA045Accident · No injuriesLimited investigationFinal reportCessna A152 · Deer Park, WADuring landing practice on an instructional flight at an uncontrolled arpt, acft was being taxiied back for takeoff after a full stop landing. Surface was icy and snow-covered. Student was practicing directional control exercise with rudder. Acft skidded and…NTSB SEA85LA032Accident · No injuriesLimited investigationFinal reportCessna 402B TS · Tonopah, NVWhile cruising at 1600 ft MSL on top of clouds, a loss of power in the left eng occurred. The plt attempted to restart the eng, but was unable. He feather the eng while diverting to tonopath, NV. The acft would not maintain alt using 1 eng. The last reported…NTSB SEA85FA034Accident · Serious injuriesField investigationFinal reportde Havilland DHC-3 Turbo · West Seattle, WAAcft was performing test flt maneuvers when problems with the modified fuel system occurred. Ice blocking a fuel vent line caused a partial collapse of the main (engine feed) fuel cell which produced an errouneous fuel quantity reading. In addition, the main…NTSB FTW85FA079Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Laredo, TXThe acft was observed to enter a downwind leg of the traffic pattern at a low alt (estimated 100 ft AGL). The witness looked away for a moment. When he looked back, he did not see the acft. A search was intiated & the acft was found where it had crashed in a…NTSB CHI85FA072Accident · No injuriesField investigationFinal reportBeech B-18S · Bellesville, MIThe plt stated that just after lift off the acft veered to the left going off the rwy striking the ground. Investigationrevealed that the plt in the left seat was receiving training & both plts were at the controls. The acft eng & airframe were inspected &…NTSB SEA85LA031Accident · Minor injuriesLimited investigationFinal reportHiller UH-12ET · Hoquiam, WAPlt reported that while in normal cruise flight, a total loss of power occurred. Autorotation was effected in mountainous, wooded terrain. Examination of the engine showed continuity and freedom of rotation. Examination of the fuel system disclosed no…NTSB NYC85LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAPlt stated that after a normal crosswind touchdown, the tail section did not drop as expected, but rose and veered left. Acft swerved and flipped inverted.NTSB NYC85FA044Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Bainbridge, NYVFR conditions prevailed when the flt departed binghamton, NY. The destination was reported as clear until just prior to the estimated time of arrival, then fog began to form. Witnesses who heard the acft, just prior to the accident, reported heavy fog. After…NTSB FTW85FA078Accident · 1 fatalField investigationFinal reportBeech V35A · Midlothian, TXN7460N, operating as mid-america flt 401, crashed while on an IFR flt plan enroute to corpus christi, TX. After having been vectored around a heavy thunderstorm & cleared direct to waco, TX. The plt contacted fort worth center & stated that he had 'lost my…NTSB ATL85LA059Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA341G · Cornelius, NCWith the executive vice president of the company acting as PIC and the company plt acting as co-plt, the acft approcahed the operator's slightly elevated helipad. According to pax statements, the acft landed hard, bounced into the air and began spinning…NTSB LAX85FA076Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Mammoth Lakes, CAThe acft tookoff from an arpt whose rwys had been closed for snow removal. A NOTAM had been filed with the fresno fss by the Mammoth lake arpt mgr at 0900 hrs for taxi and rwy snow removal. The plt was aware of the NOTAM because the mgr and a lineman both…NTSB FTW85LA080Accident · No injuriesLimited investigationFinal reportCessna 421C · Vancourt, TXAfter a complete wx brf the plt departed into known IFR cond well below apch min at the dest arpt with inadequate fuel reserves and no field alternate. After 2 missed apchs the plts desired alternate was below minimums. En route to a second alternate airport…NTSB DEN85LA046Accident · No injuriesLimited investigationFinal reportCessna 401A · Raton, NMAbout 2 hrs after departure, at 13,000 ft, the right eng fuel flow went to zero. The eng continued to operate INDICATING24 inches of manifold pressure. All other instruments were normal but what looked like a brown stain developed on top of the right wing…NTSB CHI85LA071Accident · No injuriesLimited investigationFinal reportCessna 182K · Lincoln, ILThe plt lost directional control during the landing roll. The acft veered to the right, rolled through 60 ft of sod, struck a dead furrow & nosed up. Winds were from 230 degrees at 13 KTS. The plt stated he should have used more rudder for cross wind…NTSB BFO85FA009Accident · Serious injuriesField investigationFinal reportGrumman AA-5A · Manassas, VAAfter a higher and faster apch than usual due to conflicting traffic, the acft touched down on the nosewheel and began to porpoise, according to witnesses. After the second bounce, power was added for a go around, the pilot later stated. Witnesses saw the…NTSB ATL85FA058Accident · Serious injuriesField investigationFinal reportCessna 337 · Butler, KYPilot reported rear eng failure followed by front engine. Examination of wreckage disclosed that fuel was in right fuel system, no fuel was located in left inboard system. Water was found in both engine fuel flow dividers. It was not determined if the pilot…NTSB ANC85LA030Accident · No injuriesLimited investigationFinal reportCessna U206 · Point Hope, AKThe acft crashed during takeoff while on a schedule air taxi flt. The plt & 5 passengers escaped serious injury. Investigation revealed the takeoff was attempted with suface winds reported as quartering directly across the takeoff rwy from 30 to more than 40…NTSB LAX85LA075Accident · No injuriesLimited investigationFinal reportBeech V35B · Oceano, CAThe plt made a forced landing after a total loss of power during the takeoff climb & the acft sustained substantial damage. In a subsequent conversation the plt stated that the fuel selector was either positioned on the left tip tank, or it was positioned in…NTSB LAX85FA074Accident · 2 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe acft departed on a local primary dual instructional flt at about 1030 hrs. The student was in a pre-solo phase & the lesson was to consist of a review of high airwork. The instructor (CFI) had recently become interested in & was working on aerobatics. At…NTSB LAX85FA073Accident · 4 fatalField investigationFinal reportMooney M20J · Grand Canyon, AZThe plt received a wx briefing and was advised of moderate rime and mixed icing in clouds. He filed an IFR flt plan and departed. While at 12000 ft, he reported encountering severe rime ice and requested a lower altitude. He stated thathe was trying to fling…NTSB DCA85AA006Accident · Serious injuriesFinal reportConvair 440 · Jasper, ALShortly after climbing & leveling at 6000 ft, the r eng bmep gage indicated a rapid power loss & the r eng RPM 'increased out of control' to about 3100 RPM. The aircrew retarded the r throttle & reduced the r eng to 2100 prm by using the prop…NTSB LAX85LA077Accident · No injuriesLimited investigationFinal reportCessna 177RG · Santa Maria, CAAfter touchdown on a touch-and-go lndg, acft veered left and left wing came up, raising left wheel off ground. Plt corrected with aileron and added power for go-around but acft was off runway and traversing soft terrain; lift-off speed was not attained and…NTSB LAX85LA072Accident · No injuriesLimited investigationFinal reportCessna 150F · Glendale, AZThe acft lost power & nosed over while making an emergency landing in a muddy field. Investigation revealed that fuel was being siphoned from the fuel tank vent.NTSB DEN85LA045Accident · No injuriesLimited investigationFinal reportMooney M20E · Boulder, COThe acft made an off-arpt forced landing after the engine lost power during takeoff. The flt instructor and the plt receiving instruction had flown this acft for an earlier session of training during the morning. After a break and briefing the acft was…NTSB DEN85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Nucla, COAccording to the plt, after landing on centerline brakes were applied and ice on the rwy caused the acft to veer left. An abort was initiated but realizing that the acft was going off the side of the rwy the plt secured the eng. The nose gear collapsed as the…NTSB DEN85FA043Accident · 3 fatalField investigationFinal reportPiper PA-30-160 · Albuquerque, NMThe flt was en route from forth worth, TX, to santa fe, new Mexico, when the plt decided to divert to Albuquerque. The a/c crashed while being vectored for an ILS approach to rwy 8. The plt received his instrument rating slightly more than 6 mos before the…NTSB ATL85LA057Accident · No injuriesLimited investigationFinal reportCessna 182C · Johnson City, TNThe acft crashed after a loss of eng power occurred when the plt was returning from transporting sky divers to altitude for a jump. The plt reported he ran the rt fuel tank out of fuel & failed to switch tanks.NTSB ATL85FA056Accident · 2 fatalField investigationFinal reportBeech C23 · Athens, ALThe acft was observed doing training stall type maneuvers in the area shortly before the accident. It was then observed in a steep right descending turn, crossing a paved road at low alt and striking the ground with the right wing tip. The bottom of the acft…NTSB MKC85LA055Accident · No injuriesLimited investigationFinal reportBeech 300 · Hutchinson, KSOn late final, the plt under instruction reduced pwr sharply to correct a slightly high approach, advancing the propeller controls to full increase. The combination of power reduction and increased profile drag on the propellers was excessive for the desired…NTSB MKC85FA039Accident · 1 fatalField investigationFinal reportCessna 180K · Ft.Smith, ARWitnesses along the Arkansas river observed the acft flying low over the river, in a northeasterly direction. As the acft approached a set of high voltage power lines that crossed the river aprx 85 ft above the water, it banked left and the rt wing struck the…NTSB MIA85LA060Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jacksonville, FLElectrical malfunctions caused the loss of air to ground communications and acft navigational equipment. The plt became lost about 70 mi east of Jacksonville, FL. With the help of another acft the plt located the arpt and radio communications were temporarily…