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 SEA86LA044Accident · Serious injuriesLimited investigationFinal reportBoeing 727-214 · Las Vegas, NVAfter activation of no 1 engine fire warning signals a second time, flt crew declared emerg and returned for lndg. Fuel dump was seen by some grnd observers as smoke trail and this was reported to flt crew. Acft waiting takeoff report that no smoke or fire…NTSB SEA86LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Ellensburg, WAA gust of wind occurred on short final and a loss of airspeed resulted at about 15 feet a.g.l the pilot failed to add power but raised the aircraft's nose to an attitude where he could no longer see the runway. Landing was accomplished to the left of the…NTSB NYC86LA064Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Farmingdale, NYThe acft collided with trees in the bethpage state park during a rwy 14 ILS apch at republic airport, Farmingdale, NY. The plt had instructed his passenger, a private plt, to report when he had the apch lights in sight. The plt stated the apch was continued…NTSB MIA86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D.NTSB CHI86LA070Accident · No injuriesLimited investigationFinal reportCessna 185 · St. Ignace, MIThe pilot stated that after the application of full power for takeoff his seat slid back to its full aft position. He could not reach any of the controls. He then unfastened his seat belt and lunged forward to pull the power off. At this time the right wing…NTSB ATL86LLT06Accident · Serious injuriesFinal reportPiper PA-22 · Jasper, TNThe acft crashed into a house before striking the ground in an uncontrolled descent. The acft was approaching marion arpt for a landing when the plt lost control. The plt said that the stabilizer adjustment 'stripped'. The pilot was using the trim tab when…NTSB ATL86LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Rural Retreat, VAPilot said first adf approach terminated by missed approach due to oscillating directional needle. On second approach acft broke out of clouds with trees in front of acft. It impacted a cloud obscured ridge 3.5 miles southeast of airport on a southerly…NTSB ATL86LA060Accident · No injuriesLimited investigationFinal reportCessna 182Q · Carthage, MSWhile on final approach for landing the pilot advanced the throttle to adjust his final approach path and the engine lost power. The aircraft impacted the ground short of the runway and flipped inverted. The engine was later test run and performed to…NTSB ANC86LA022Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe pilot stated that during the initial climb out approximately 50 feet above the ground the engine quit. The aircraft crashed into a row of trees and the pilot was not injured. Examination of the aircraft engine revealed no malfunction or mechanical…NTSB SEA86LA043Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Sloan, NVAcft was observed performing low-level aerobatics, failed to complete pull-out from second consecutive overhead maneuver, striking ground in 20-30 degree nose-low attitude. No evidence of pre-impact mechanical failure or malfunction found in acft structure,…NTSB MKC86FA053Accident · 4 fatalField investigationFinal reportCessna 210H · Fremont, NEThe plt of N5961F received a wx brf about 40 min before the acdt for a VFR flt from Fremont to cheyenne. The 3 reporting stations nearest to Fremont were IFR and local authorities who helped search for the acdt site reported low clouds and haze. There were no…NTSB MIA86LA060Accident · No injuriesLimited investigationFinal reportBeech B24R · Fernandina Bch, FLThe plt stated that just after he rotated, he experienced a loss of power, extended his landed gear & landed hard causing a collapse of the landing gear. Post crash examination of the eng revealed that the right magneto was improperly timed & the left magneto…NTSB LAX86LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Woodland, CAThe pilot reported that he experienced a loss of power shortly after leveling off at about 1,000 MSL. The power loss was smooth and rapid. During the subsequent forced landing roll-out, the acft nosed over onto its back. Post accident investigation disclosed…NTSB DEN86LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cedar City, UTThe plt stated that while in cruise flt, a loud noise was heard followed by air entering the cockpit. The plt said he initially reduced pwr, not knowing what the problem was. According to the plt, when no visual problem with the aircraft was found, he added…NTSB CHI86FA068Accident · 1 fatalField investigationFinal reportCessna 177RG · Valley View, ILThe plt was conducting a low pass, 40 ft AGL, on a river and struck a power line crossing his flt path. The strike caused loss of control and the acft impacted on the frozen surface of the river.NTSB ATL86LA059Accident · No injuriesLimited investigationFinal reportBeech A36TC · Louisville, KYPlt attempted t.o. from slush covered rwy with about 1/2 to 3/4 inch of snow on acft. When snow did not blow off the wings, abort attempted at between 80-100 knots. Acft went off the end of the rwy and through fence before coming to a stop on the golf course…NTSB SEA86FA041Accident · 1 fatalField investigationFinal reportCessna 182 · Juneau, AKPilot requested clearance to return to airport after takeoff due to eng power loss. Clearance was given by ATC. Pilot made rt turn from about 100 ft alt. Acft crashed about 1500 foot south of rwy. No shoulder harnesses installed. Pax survived. Ice found on…NTSB NYC86LA065Accident · No injuriesLimited investigationFinal reportCessna 305-L-19 · Hilltown, PAThe Cessna was towing a glider when at an altitude of about 150 feet to about 200 feet, a decrease in RPM was experienced. The glider was detached from the aircraft, the nose was lowered and a left turn made while still over the gliderport. A rapid descent…NTSB NYC86LA063Accident · No injuriesLimited investigationFinal reportLuscombe 8B · Turin, NYThe personal flight from oswego, NY to Turin, NY was uneventful and without problems. However while landing in soft snow, the right ski dug into the soft snow. The landing gear failed and the aircraft nosed over onto its back and was substantially damaged.…NTSB MKC86LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, MODuring an aborted takeoff in strong crosswinds, the acft veered off the rwy and into a ditch near the runways edge. The nose gear collapsed rearward and the right wing dropped striking the ground. The plt stated he aborted the takeoff when the acft felt like…NTSB LAX86LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Cottonwood, AZThe acft had not been flown for about 4 yrs. The plt intended to fly it to chandler, AZ, for an annual inspn. The pax stated the plt had previously made a test flt, but had a problem starting the eng. Rprtdly, the plt 'cleaned the fuel system and filled the…NTSB FTW86LA037Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Yukon, OKThe left brake locked after the aircraft rolled a short distance during landing. Aircraft slowed until about 20 mph forward speed and then flipped inverted and stopped. Post accident examination revealed the brake shoe return spring on the left brake was…NTSB DEN86LA068Accident · Minor injuriesLimited investigationFinal reportCameron 0-77 · Rio Rancho, NMThe plt stated that during the inflation of his balloon, the safety line holding the basket to his support vehicle broke during windy conditions. According to the plt, he tried to inflate the envelope in order to climb above buildings nearby. The plt…NTSB CHI86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mechanicsburg, OHThe plt was on a personal flt when IMC was encountered. The plt elected to climb to a clear area above the IMC when the acft became totally 'socked in.' A 180 deg turn was made, vertigo was experienced and control of the acft was lost. An emergency descent…NTSB CHI86LA072Accident · No injuriesLimited investigationFinal reportBeech A23A · Hastings, MIThe pilot estimated he had 13 gallons of fuel on board for the estimated fifty minute flight. He estimated his fuel burn at nine gallons per hour giving him an hour and twenty five minute fuel endurance. He ran out of fuel an hour and twenty five minutes…NTSB ATL86FA058Accident · 4 fatalField investigationFinal reportCessna 310G · Ragland, ALThe acft with sputtering engs was heard circling overhead in low overcast skies. The horizontal tail surfaces separated in-flt and came to rest aprx 450 ft from the main wreckage in mountainous terrain. The student plt had no instrument experience. The acft…NTSB ATL86FA057Accident · Serious injuriesField investigationFinal reportCessna 210M · Tucker, GADuring a night VFR flt the acft experienced a total loss of power and made a forced landing in a small parking lot in a business area. When rescue personnel asked the plt what had happened he stated that the acft ran out of fuel. Inspection of the wreckage…NTSB NYC86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Dover, VTDuring the landing roll on ice covered runway the aircraft ran off the departure end of the runway and collided with a snow bank.NTSB LAX86LA093Accident · No injuriesLimited investigationFinal reportRockwell 112TC · San Carlos, CAThe acft experienced a loss of eng pwr at an alt of aprx 400 ft AGL during a takeoff climb. The plt made a forced landing in a muddy fld next to the rwy and the acft nosed over. The plt thought the single drive dual magneto had failed but could not be…NTSB LAX86FA092Accident · 1 fatalField investigationFinal reportCessna T210N · Indio, CAThe plt was on a 21 mi flt fm his home arpt to thermal, CA, to practice takeoffs & lndgs. Bfr departing, he successfullyread back a VFR clnc to fly out of the palm springs trsa. Shortly after takeoff, while en route twd the se (twd the sun,which was 22 deg…NTSB FTW86FA035Accident · 3 fatalField investigationFinal reportBeech M-35 · Valley View, TXThe non-instrument rated pvt plt received a wx briefing that called for marginal VFR to IFR conditions throughout his route of flt. Destination wx was briefed as 700' ovc, vis 2 miles in haze and fog and the en route wx was considerably worse. Several…NTSB DEN86FA066Accident · 2 fatalField investigationFinal reportBeech V35B · Leadville, COThe plt departed pueblo, Colorado on a VFR flt toward an approaching frontal wx system. Radar data showed the acft climbed to an altitude of 18,200 ft MSL, with erratic maneuvering in the vicinity of accident site. The wreckage was located at 13,200 ft MSL in…NTSB DCA86AA014Accident · No injuriesFinal reportBoeing 727-225 · Loudon County, VAThe rt main lndg gear would not extend for lndg at wash natl arpt. The lndg was aborted and the crew attempted to correct the situation but were unsuccessful. An emergency gear-up lndg was made at dulles internatl arpt. The crew and passg evacuated without…NTSB CHI86LA069Accident · No injuriesLimited investigationFinal reportBeech BE-90C · Canton, OHAfter making a coupled ILS approach to 300 feet, the pilot stated he could not disconnect or override the autopilot. He subsequently landed hard and bounced, snapping the nose gear off. The aircraft came to rest on its nose with both propellers contacting the…NTSB ATL86FA062Accident · 5 fatalField investigationFinal reportCessna 337G · Blairsville, GAAcft was flown VFR from ravenna, Ohio en route to atlanta, GA. It departed ravenna about 0930 01/17 & failed to arrive at its destination. Family reported acft missing. Air force rescue center notified at 2020 01/19. Cap commenced air search 01/20, hampered…NTSB SEA86FA039Accident · 1 fatalField investigationFinal reportHiller-Soloy UH-12E · Horton, ORThe fork connecting the rotorcraft's blue blade to the main rotor hub separated after a long term fatigue crack had spread through more than 60% of the fork circumference. The operator failed to carry out the appropriate inspection of the fork unit as…NTSB NYC86LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Durhamville, NYThe flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…NTSB LAX86LA091Accident · Minor injuriesLimited investigationFinal reportBell 206B-3 · Waimea, HIWhile on a local flt, the plt descended to aprx 500 ft AGL and flew the helicopter along a coastal area. He reported the helicopter suddenly lost power and he initiated an autorotative landing to the beach where the helicopter 'had a hard landing.' An exam…NTSB DEN86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sterling, COAccording to the plt, during the checkride for his commercial plt certificate, the flt examiner gave him a simulated electrical failure & turned the landing lights off. The plt stated that during the night landing flare, he lost visual reference with the rwy…NTSB CHI86LA067Accident · No injuriesLimited investigationFinal reportSikorsky S-58F · North Adams, MIWhile accomplishing preflight systems checks with the engine running and the rotor system engaged the aircraft experienced a hydraulic hardover. Uncommanded displacement of the flight controls caused the aircraft to pitch up and left simultaneously. The pilot…NTSB BFO86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, VAThe student pilot stated that uneven braking during landing caused the aircraft to swerve off the side of the runway. He further added that he applied full power shortly thereafter due to the fact that the aircraft was heading for a ditch. The aircraft…NTSB SEA86LA040Accident · No injuriesLimited investigationFinal reportCessna 501 · North Bend, WAWhile on final the fss gave the pilot the current winds and the favored runway. The pilot was attempting to land the aircraft on runway 04 with a right gusting quartering tail wind and wet runway. Hydroplaning occurred and the pilot elected to go-around when…NTSB SEA86FYA01Accident · Serious injuriesFinal reportWorld Wide Industries Spit Fire #2 · Caldwell, IDThe pilot of this ultralight said there was a loss of engine RPM. The aircraft was then damaged during an off airport landing. The pilot was not injured but the passenger received serious injuries. This ultralight aircraft did not meet the criteria for…NTSB MKC86LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbia, MOThe pilot stated that he was showing his passenger a procedure that he used in multi-engine airplanes when he inadvertently stalled the airplane at 300 feet AGL just after takeoff. He could not complete the recovery before impacting the runway.NTSB FTW86LRA04Accident · Minor injuriesFinal reportEagle DW-1 · Bremond, TXAccording to the pilot, the aircraft was being operated by thompson flyers of garwood, inc., rt 1, box 214, marlin, TX. In agricultural aircraft operations under FAA ag operation certificate no. SW-HOU-97-AG. The aircraft had completed its last swath run…NTSB ATL86LA056Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Conway, SCDuring night flight instruction for takeoff and landing practice, the aircraft collided with trees off the approach end of the runway and impacted the ground 800 feet short of the runway. The runway had been recently extended and the trees off the end of the…NTSB ATL86FMG03Accident · Minor injuriesFinal reportCessna 441 · West Columbia, SCDuring final approach the plt noticed acft flying 'unusual' and elected go-around. During power-up, the acft lost power and a forced landing was made on a residential street near the arpt. The plt stated that he had inadvertenly placed the fuel selector in…NTSB SEA86LA038Accident · No injuriesLimited investigationFinal reportCessna 150-M · Mead, WAThe pilot was attempting to land on the runway which was covered with 11 inches of snow. The main gear dug into the snow and the right wing tip caught turning the aircraft sideways.NTSB CHI86LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pelican Rapids, MNThe exhaust valve rocker arm #1 cylinder failed in flight. The student pilot descended and landed in a wooded area. After over flying a frozen lake occupied by fishermen. The rocker arm exhibited evidence of fatigue.NTSB CHI86LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Warren, MNThe pilot overflew the runway & observed some snow on the left hand side of the runway. During the landing the aircraft drifted to the left, collided with a finger drift & nosed over.