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 NYC87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Marienville, PAThe Cessna 172 experienced a total loss of power while cruising at 4000 ft on an IFR flight plan. The pilot made a landing on a road and clipped a road sign after touchdown, the aircraft swerved into a ditch and received susbtantial damage. The two occupants…NTSB MKC87LA047Accident · No injuriesLimited investigationFinal reportCessna 182C · Rolla, MOThe engine started running rough enroute and pilot was able to get it running smoothly but he continued to his destination. Airplane was too high on approach so pilot went around. On downwind, engine started running rough again and pilot was unable to correct…NTSB FTW87LA057Accident · 2 fatalLimited investigationFinal reportBell 206L-1 · Matagorda 665The plt took off fm an off-shore oil platform with 3 pax on board. Shortly after depg, he transmitted a 'mayday,' but did not state the nature of the emerg. A pax rprtd that the eng sound changed & the plt told him to 'get the raft out.' Subsequently, the…NTSB FTW87FA059Accident · 2 fatalField investigationFinal reportSikorsky S-76A · Angleton, TXShortly after tkof, the plt contacted his company (opns) & said he had inadvertently enctrd IFR conds. He asked opns to relay info to him fm the apch plate for the ILS rwy 17 apch to brazoria county arpt. After rcvg the info, he contacted houston apch ctl &…NTSB CHI87LA075Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Dodgeville, WIWhile taxiing after landing on runway 12, a tailwind was encountered. The acft spun around, slid backwards off the rwy, down a steep embankment and struck a large rock. The plt reported winds from 270 degrees at 12 knots gusting to 18 knots.NTSB ANC87LA034Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Paxson, AKThe pvt plt took off at night and flew into instrument conditions. He had failed to unlock the direction gyro until the acft entered the clouds. The acft crashed 32 miles from the departure point due to fuel exhaustion. Automotive fuel was being used in the…NTSB NYC87LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Duanesburg, NYOn lndg the acft ran into a snowbank causing minor dmg to the acft. Aft determining it airworthy the plt elected to depart and ran into another snowbank on the takeoff. He stated that the accd occurred because of poor judgement to attempt a takeoff from an…NTSB LAX87LA108Accident · No injuriesLimited investigationFinal reportCessna 172N · Yuma, AZA Cessna 172M veered left during takeoff ground run on rwy 8 and nosed down on the rwy. The plt indicated that he encountered a left 90 degree x-wind gusting up to 20 KTS. The acft began to veer uncontrolled into the wind. He elected to abort the takeoff at…NTSB FTW87LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Kingfisher, OKThe pilot stated that he was demonstrating emergency landing procedures to the student pilot. At about 1000 AGL he instructed the student to apply full power for a go around. According to the pilot, the engine developed full power for about 30 sec. And…NTSB CHI87LA077Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bridgman, MIPlt was attempting to takeoff from a soft field. The gear caught a rise in the field and acft settled back to the soft ground tearing off the nose wheel and damaging both wings.NTSB CHI87LA074Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntington, INWhile executing a touch & go landing, the plt reports that during the takeoff phase she was slightly left and tried to correct to the right when the left wheel caught in snow and the acft pulled off the rwy to the left. The acft flipped over and came to rest…NTSB ANC87IA032Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Barter Island, AKThe pilot flew into rising terrain during a night VFR flight. After shutting down the right engine and achieving only partial propeller feather he elected to make a gear up landing. The plt was flying at 500 ft AGL when he wandered from over water to on-shore…NTSB ANC87FA031Accident · No injuriesField investigationFinal reportChampion 7EC · Anchorage, AKThe pilot-in-command accomplished unauthorized repairs to his airplane after an incident four days earlier. He repaired the right main landing gear by using a common door hinge to attach it to the fuselage. Upon landing, the door hinge failed and control of…NTSB FTW87LA062Accident · No injuriesLimited investigationFinal reportCessna 210 · Bonham, TXAccording to the pilot, the aircraft made a normal landing, but was substantially damaged when the aircraft contacted a ditch cut across the airstrip, causing the aircraft to nose over inverted.NTSB FTW87LA053Accident · No injuriesLimited investigationFinal reportBellanca Scout · Boyd, TXA private pilot landed on his private strip made of soft sandy soil, the aircraft ground looped breaking the left main gear 'u' bolt and center bolt. The aircraft's left wing contacted the ground causing substantial damage when the aircraft rolled over on its…NTSB FTW87FA054Accident · Serious injuriesField investigationFinal reportPiper PA-22-135 · Floresville, TXThe pilot heard a sudden change in engine sounds during flight and realized his muffler had failed. He was flying about 1000 feet above ground level and initiated a descent to 250 feet. Heat and flames started entering the cockpit through the cabin heat inlet…NTSB FTW87DRD03Accident · Serious injuriesFinal reportSikorsky S-55C · Kurthwood, LAThe engine surged and subsequently lost power during low altitude cruise flight above a dense forest. The pilot autorotated into the trees and then fell through onto the ground. Post accident examination revealed water contamination in the fuel system.NTSB NYC87LA074Accident · No injuriesLimited investigationFinal reportCessna 152C · Washington, CTThe flight departed newport state airport, newport, rhode island on a student solo cross country enroute to waterbury, Connecticut. While over Washington, Connecticut, the aircraft began losing rpms and altitude. The acft was substantially damaged during the…NTSB MKC87LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Flippin, ARThe pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after…NTSB LAX87LA106Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Plaster City, CADuring a local business flight the pilot was flying low, approximately 50 ft AGL, and slow with 30 degrees of flaps extended to take aerial photographs of a motorcyclist on the ground. Upon completing a 360 degree turn to the left, the aircraft flew through…NTSB LAX87DVD01Accident · Serious injuriesFinal reportBell 47G4A · Stockton, CAJust after takeoff, the engine experienced a power loss while transporting agricultural equipment. A fractographic examination of the failed fuel disconnect fitting by anamet laboratories, concluded that approximately 70% of the retaining ring on the fuel…NTSB LAX87DJA04Accident · 1 fatalFinal reportGlaser-Dirks DG-400 · Dillingham, HIThe aircraft was observed flying over a ridge at a 'good rate of airspeed'. It turned back towards the ridge and collided with the terrain. There was a SIGMET in effect for moderate to severe turbulence. Investigation revealed no preimpact mechanical…NTSB FTW87LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marfa, TXThe pilot stalled the aircraft while attempting to climb too steeply during takeoff from an old abandoned airport. The aircraft veered left, descended, and struck the ground before flying speed could be regained.NTSB DEN87FA050Accident · 1 fatalField investigationFinal reportCessna TR-182 · Moran, WYThe pilot received several weather briefings prior to departure. Briefings included reports of icing conditions, low clouds and turbulence. VFR flight was not recommended. Plt departed VFR and filed IFR enroute to jackson. The pilot was issued instructions…NTSB CHI87LA073Accident · No injuriesLimited investigationFinal reportCessna 182M · East Troy, WIThe aircraft was cruising at approximately 2000 feet AGL when the engine began running rough. The plt stated that he added carburetor heat and leaned the mixture, but the engine continued to run rough. The plt elected to make a precautionary landing in an…NTSB CHI87DEE04Accident · 1 fatalFinal reportCessna 172 · Plainfield, ILWhile taxiing for takeoff, the aircraft became stuck in a snowbank. The pilot and passenger got out of the aircraft to free it. The passenger walked into the propeller of the running engine and received fatal injuries.NTSB BFO87LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200R · West Point, VAAfter making a low pass over the uncontrolled airport the CFI decided to let the student pilot make a touch and go landing on runway 27 at West Point municipal airport. West Point, Virginia. The maneuver was successfully completed and the aircraft came around…NTSB NYC87LA075Accident · No injuriesLimited investigationFinal reportCessna 172K · Butler, PAThe personal flight with four occupants on board landed about 40 feet short of the runway after completing two successful touch and go landings. Pilot stated that the wind was at 220 degrees at 10 knots.NTSB NYC87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Shelburne, VTPilot misjudged height of snowbank at the approach end of the runway and allowed the aircraft to descend too low. The main gear collided with the snowbank causing substantial damage.NTSB NYC87LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawrence, MADuring a simulated engine out, the aircraft collided with power lines, while climbing out after descending over a possible landing area. The aircraft was able to continue flight and land at bedford, Massachusetts without further incident.NTSB NYC87LA071Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Rockaway, NJStudent pilot experienced a rough running engine during cruise flight and decided to make a precautionary landing on a frozen reservior. During landing roll out, the aircraft hit a slushy spot on the ice and nosed over causing substantial damage.NTSB MKC87FA044Accident · 2 fatalField investigationFinal reportCessna 150D · Central City, NEAt about 0305 CST, witnesses in vehicles saw the acft lndg lgt as they were driving along a hwy. they rprtd the lgt was moving erratically as the acft was proceeding along the hwy at low alt. Subsequently, the acft struck a utility pole & power lines, then…NTSB MIA87FA080Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Venice, FLAircraft was seen maneuvering at between 200 and 300 feet in attempts to locate a lost radio controlled model airplane. As the aircraft completed 2 and one half turns it leveled out and began a climb to the north at which time it collided with a 504 foot…NTSB LAX87LA107Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Riverside, CAA Luscombe 8A ground looped on landing roll. The pilot indicated that during the landing roll after his third landing he heard a 'pop' sound. The aircraft veered right, collapsing the left main landing gear and damaging the left wing. After the accident the…NTSB LAX87FA103Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Gualala, CAThe student plt, flying his own acft, took off under VFR conditions for an intended 45 min solo cross country flt. The plt encountered deteriorating wx & attempted to return to the departure airport. A witness observed the aircraft enter clouds, turn left &…NTSB FTW87LA065Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Midlothian, TXThe acft was substantially damaged when the left wing struck a 4 inch diameter post on landing. The plt stated that he decided that due to a crosswind, he would land diagonally across the north/south rwy that was mowed in the middle of a large open field…NTSB FTW87LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Worth, TXPrivate pilot in Cessna 172P with three passengers aboard attempted to take off with 60 degree, 9 knot cross-wind component. Pilot rotated aircraft prematurely causing stall warning horn to activate and airspeed to dissipate. Pilot lowered nose of aircraft in…NTSB DEN87FA048Accident · 2 fatalField investigationFinal reportCessna 340A · Two Buttes, COThe plt and his wife were en route from palm springs, CA, to olathe, KS, and had stopped for fuel at farmington, NM. After departure, the acft was eventually cleared to FL 210. At 1934 the plt gave denver ARTCC the following PIREP: 'there's been some snow but…NTSB BFO87LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodbridge, VAThe student was attempting the last of 3 full stop landings. The landing was made at minimum airspeed. The acft touched down left of the rwy centerline where afterwards the l main gear hit a snowbank alongside the rwy. A loss of directional control occurred…NTSB ATL87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay Varina, NCThe student plt reported that the lt main wheel rolled off the rwy into mud during ldg rollout. This pulled the acft off the rwy and down an embankment into a ditch. The nose gear subsequently sank into the mud and the acft nosed down. The acft came to rest…NTSB ATL87DLQ01Accident · 1 fatalFinal reportAir Command CDR Elite 532 · Paducah, KYWhile conducting local traffic pattern training, the gyroplane undershot runway 22 during an attempted landing. The plt was killed in the crash. The investigation failed to disclose any aircraft problems. The autopsy revealed severe coronary arterisclerosis…NTSB ANC87LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Beluga, AKThe pilot stated that during the landing roll on a snow covered road the pilot lost control of the aircraft causing the aircraft to nose over on its back.NTSB MIA87IA081Incident · No injuriesIncident investigationFinal reportEnstrom F28C · Boca Raton, FLThe helicopter spun uncontrollably on the ground after the right anti-torque pedal cable was severed while landing. Examination of the helicopter revealed that the teter stop failed to limit the travel of the tail rotor spindle assy thereby reducing the…NTSB LAX87LA105Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58B · Los Angeles, CAA Sikorsky S-58B collided with a marked 253 ft AGL antenna tower (twr) while maneuvering over external load lift site. The plt indicated that he was sitting in the right seat of the acft in a right descending orbit conducting a site recon and that he was…NTSB LAX87LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Marana, AZDuring a winch tow, the cable prematurely released the glider at approximately 100 to 150 feet. The glider remained in a nose high attitude momentarily then began a shallow descending right turn. At approximately 75 feet the roll, pitch, and descent rate…NTSB LAX87FA102Accident · 2 fatalField investigationFinal reportCessna 172P · Cuyama, CAThe plt rcvd a preflt briefing before a morning dep fm monterey. At that time, the forecast was for 3000' to 5000' broken clouds with widely scattered rain showers by 1600 & with a gen outlook of VFR. The plt flew to santa barbara to attend a meeting & depd…NTSB FTW87LA055Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Jacksonville, TXThe pilot stated that he had added oil to the engine prior to his departure on a sight seeing flight, but on scene investigation revealed that the engine froze from oil starvation. No evidence of leakage was found. The aircraft had been owner-maintained for…NTSB DEN87LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Taos, NMThe non-instrument rated plt inadvertently flew into IMC wx; snow, fog, freezing temperatures and low visibility, in mountainous terrain. He made a forced landing on a trail due to lowering visibility, 15 miles southwest of the destination arpt. The terrain…NTSB CHI87LA072Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Martinsville, INWhile landing to the east the plt was blinded by the sun and the acft struck telephone wires.NTSB CHI87DER02Accident · Serious injuriesFinal reportCessna 150M · Lakeville, MNThe student & instructor (CFI) were preflighting the acft to fly on a cold morning. To facilitate better eng starting, the CFI elected to turn the prop while the student 'pushed the primer in.' He told the student to check that the mag & master sws were off &…