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 SEA85LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, ORThe plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion…NTSB SEA85LA200Accident · No injuriesLimited investigationFinal reportCessna 180A · Buxton, ORThe pilot misjudged his touchdown point on the 1,000 foot airstrip and had an excess of airspeed. And overrun occurred and the aircraft went down an embankment. At the time of touchdown, there was only about 4 KTS of headwind available.NTSB NYC85LA217Accident · No injuriesLimited investigationFinal reportPiper J-3 · Goshen, NYAcft ran out of fuel while plt was returning to orange co arpt. Plt almost froze on controls when acft engine stopped running. Plt overshot emerg landing fcd and hit trees.NTSB NYC85LA216Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Provincetown, MAPlt experience eng pwr loss during tke climb at a height of about 350 ft. the plt headed toward a beach and ditched about 50 yards offshore in order to avoid crowd. The acft submerged underwater afterwards. Examination of the acft disclosed leadlike…NTSB NYC85LA215Accident · Minor injuriesLimited investigationFinal reportBell BH206L-1 · Hawley, PAThe helicopter arrived at a private residence to transport race car drivers to the pocono raceway. During departure the pilot failed to see powerlines in the flight path that contacted the main rotor system. The main rotor system failed and the helicopter…NTSB NYC85FNA03Accident · Serious injuriesFinal reportPiper PA-28-151 · Newburyport, MAThe pilot attempted a landing at night with an inoperative landing light and no runway lights. After circling the airport 3 or 4 times he attempted a landing. The aircraft received substantial damage and the pilot received serious injuries. The passenger…NTSB NYC85FFA03Accident · Minor injuriesFinal reportCessna 172L · Parishville, NYThe pilot was attempting a landing in a Cessna 172L on a 1250 ft grass runway. He misjudged his touch down point and landed approximately 1/2 way down the runway. The aircraft was unable to stop on the remaining runway and ran off the departure end of the…NTSB MKC85FA191Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · New Madrid, MOA witness said N267CD made a low pass down the farm airstrip and as the acft neared the end of the strip, it began a climb, banked to the left and descended to the ground. The acft impacted in a nose low, left wing low attitude.NTSB LAX85LA354Accident · No injuriesLimited investigationFinal reportCessna 182Q · Safford, AZThe aircraft experienced a partial engine power loss after departing Safford municipal airport on a VFR personal flt to sky harbor arpt, phoenix, AZ. The plt negotiated an emerg lndg in a flt brush area. Prior to touchdown the acft struck a mesquite tree and…NTSB LAX85LA353Accident · No injuriesLimited investigationFinal reportMike Stone Moni · Byron, CAWhile on the initial test flt, the amatuer-built r. m. stone moni acft crashed near Byron, CA. The plt reported that during the flight the acft began to 'flutter', followed by separation of the canopy. Shortly thereafter the acft entered into an…NTSB LAX85FA355Accident · Serious injuriesField investigationFinal reportCessna 150L · Rialto, CAThe christian eagle biplane was returning from a local instructional flight and entered the pattern on a normal 45 degree entry, announcing position and intentions on the UNICOM frequency. The Cessna 150 was departing the airport on a local instructional…NTSB FTW85LA327Accident · No injuriesLimited investigationFinal reportCessna 150M · Lubbock, TXThe plt was advised that he was cleared for an intersection takeoff on rwy 17R. After his run up, the plt attempted a night takeoff to the north on an unlighted taxiway that ran parallel to the active runway. Controllers advised the pilot to abort, which he…NTSB DEN85FA222Accident · 4 fatalField investigationFinal reportCessna 172P II · Cedar City, UTThe plt took three of his friends up for a pleasure flt in the local area of Cedar City, Utah. VMC prevailed at the time. The plt continued to climb his acft as it passed over rising terrain. The flt terminated in a box canyon with high terrain on all sides.…NTSB CHI85LA352Accident · No injuriesLimited investigationFinal reportHughes 269A · Hector, MNAfter liftoff from an open field, on a short local flight the helicopter experienced fuel exhaustion. During the auto rotation landing, in an open field the helicopter rolled on the side.NTSB ANC85LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Fairbanks, AKDuring landing the plt applied hard braking to avoid an airplane and rolled over.NTSB ANC85LA153Accident · Serious injuriesLimited investigationFinal reportStinson 10A · Wasilla, AKThe acft contacted trees during a forced landing following a loss of pwr which resulted from fuel exhaustion during an initial takeoff climb. The plt attempted to land on a road, however, when a car pulled onto the road, the plt flew the acft into trees. Only…NTSB ANC85FA154Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 MK.1 · Tutna Lake, AKThe acft crashed on the side of a mountain at an elev of 2200 ft aprx 3 miles from its intended destination, a remote lake. Purpose of the flt was to discharge caribou hunters into an area where caribou were spotted early that day. The acft was destroyed by…NTSB NYC85FHJ05Accident · No injuriesFinal reportMaule M-4-220C · Somers, NYThe acft stalled & nosed over during an attempted go-around after a fast approach to a gravel landing strip which was 5 miles from the planned destination. The plt said he added power to go around when he thought his airspeed was too high. The acft dropped on…NTSB NYC85FA213Accident · 1 fatalField investigationFinal reportCessna C-305A · Brooklyn, NYDuring an aerial banner tow operation at low level along the beach, witnesses observed the airplane bank sharply to the right and dive into the water. Witnesses recall the engine noise to have been loud yet sputtering before the impact. Inspection of the…NTSB MKC85LA190Accident · No injuriesLimited investigationFinal reportPezetel M18 Dromader · Wilmot, ARAt lift-off fm a private ag-strip the plt experienced an abrupt right yaw. The plt stated he compensated with left pedal to maintain straight and level flt. The plt stated he was unable to maintain altitude and dropped his load of chemical during which the…NTSB MKC85LA188Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lee'S Summit, MOThe plt reported that the eng start & run-up were normal before he took off on a night currency & proficiency flt. After 2 normal takeoffs & full stops, he made a 3rd takeoff. He climbed to 1000 ft AGL on a x-wind leg, reduced power to 20' manifold pressure &…NTSB MKC85FA189Accident · Serious injuriesField investigationFinal reportBell 47G-2A · Sedalia, MOThe plt was taking 2 passengers on a helicopter ride at a fair. Immediately after lift-off, he encountered a situation where he was unable to maintain directional control, so he reduced power & landed. Before coming to rest, the tail of the helicopter struck…NTSB MIA85LKG04Accident · No injuriesFinal reportCessna A188B · Bainbridge, GAThe acft stalled during aerial application operations and collided with the ground. The plt said the wind was gusting to 30 KTS and during a steep downwind turn the loaded acft stalled at 100 ft AGL. The plt recommended less steep turns and not operating in…NTSB FTW85LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Llano, TXThe plt stated he entered the traffic pattern at 2000 ft for a left downwind to rwy 17. He then reduced pwr to 1700 RPM and placed the mixture control into the full rich position. He assured that carburetor heat was off and then started his descent. The eng…NTSB FTW85LA324Accident · Minor injuriesLimited investigationFinal reportDouglas TB-26B · Pattonville, TXThe acft had not flown for two years and was being checked out for a ferry flt to the U.S. Air force air museum in fargo, ND. During initial climb from cox field at paris, TX, the left eng lost total pwr and the right eng lost partial pwr. An off arpt forced…NTSB DEN85LTG09Accident · No injuriesFinal reportPiper PA-30/A · Bowman, NDThe acft was landed gear up. The plt was aware of the condition at one point in the traffic pattern. A check by retarding the throttle(s) on final produced no warning horn so the plt assumed that the gear was down. After the gear up landing, the circuit…NTSB DEN85LA223Accident · No injuriesLimited investigationFinal reportCessna 120 · Erie, COThe plt stated after the accident that she had landed and the acft rolled aprx 600 ft when she attempted to turn off onto the taxiway while the acft was traveling at a moderate speed. A witness stated that he saw the trees 'lock up' as the acft approached the…NTSB CHI85FEV02Accident · Serious injuriesFinal reportde Havilland DH-82A · Elmore, ILWhile on a x-country flt, the eng lost power & the prop continued to windmill. Subsequently, the acft crashed during an emerg landing. During the crash landing, the plt's shoulder harness failed at the upper attachment point & he received head & back…NTSB CHI85FEK02Accident · Serious injuriesFinal reportUnknown Quickie · Wren, OHOn August 17,1985 at about 1442 EDT, a Q2 quickie (homebuilt) N4253F, registered to gary a. moser and flown by keith w. moser crashed while performing maneuvers 1/2 mile southeast of Wren, Ohio, while on a personal flight. VFR meteorological conditions…NTSB ATL85LA250Accident · No injuriesLimited investigationFinal reportCessna A-188B · Winterville, MSDuring pull-up from a swath, the acft stalled & descenced into trees. The plt related that he pulled up into a tight turn causing the acft to stall.NTSB ATL85LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Yanceyville, NCThe non instrument rated private pilot flew into know adverse wx conditions. While receiving vectors to the nearest airport, the eng lost power dur to fuel exhaustion and an emergency landing was made in a field near a private residence.NTSB ATL85FA252Accident · 4 fatalField investigationFinal reportMooney M20C · Columbus, GAAcft departed airport after enroute stop for fueling.VFR conditions with broken clouds at 2800 feet and turbulence in clouds. Acft was cleared to 4500 and PIC asked to report reaching. During climb PIC was asked his altitude. His response was unintelligible…NTSB ANC85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe plt reported sufficient alt could not be obtained to clear trees during takeoff. The acft stalled and the right wing contacted the water resulting in the acft cartwheeling. Investigation revealed the acft was over gross weight and CG was beyond the aft…NTSB SEA85FA198Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Sparks, NVAcft exhausted fuel enroute to destination during cross coun try night flgt. Plt advised ATCT of loss of engines about 20 miles out. Plt made deadstick landing on hwy, struck bridge divider. No fire or reported injures. Inspection disclosed dry fuel tanks.NTSB NYC85LA214Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Montgomery, NYThe plt reported that the flt was uneventful until he was in a descent about 12 mi from the destination arpt. He said that a large bird suddenly appeared in front of the acft & collided with the right wing. The bird strike put a large hole in the right wing…NTSB MIA85LKG05Accident · No injuriesFinal reportCessna L-188 · Camilla, GAThe plt stated that during a swath run at an alt of aprx 5 ft AGL, a sudden loss of pwr occurred. The acft was damaged when it settled and contacted the terrain. Post accident inspection and a test run of the eng failed to reveal any mechanical…NTSB MIA85LA236Accident · No injuriesLimited investigationFinal reportMooney M20F · Ft. Myers, FLThe acft settled to the rwy during the takeoff roll after the landing gear retracted. The plt stated that the landing gear collapsed for an unknown reason. A post accident inspection of the landing gear and related components revealed no defects or…NTSB LAX85LA356Accident · No injuriesLimited investigationFinal reportCessna R182RG · Hilo, HIOn August 16, 1985, a Cessna 182 ditched at sea following fuel starvation about 200 miles northeast of Hawaii while on a ferry flight. The pilot reported that he had 23 hours of fuel onboard for the 16 hour flight. The aircraft was equipped with auxiliary…NTSB LAX85LA352Accident · No injuriesLimited investigationFinal reportCessna 182K · Pioneer, CADocuments provided by the plt established that 45.5 gallons of fuel were loaded on the aircraft prior to departure from watsonville, California, the day prior to theaccident. The flt flew direct to minden, Nevada, a straight line distance of 170 NM, where it…NTSB LAX85LA350Accident · No injuriesLimited investigationFinal reportCessna 182A · Santa Paula, CADuring a cross country flt the acft experienced fuel exhaustion and collided with ground obstructions during the subsequent forced landing in a river bed. The plt said 4 hrs and 20 mns of engine run time had elapsed since the last fueling of the acft. At the…NTSB DEN85LA221Accident · No injuriesLimited investigationFinal reportBeech E18S · Billings, MTThe plt stated that he encountered a 'wind draft' and the acft was struck by lightning. The rt eng mount failed and the rt eng was deflected downward. Plt was unable to maintain alt and executed a forced landing in an open field. Post crash exam of the welded…NTSB CHI85LA350Accident · No injuriesLimited investigationFinal reportCessna C-172P · Zanesville, OHPlt aborted takeoff from taxiway when he realized that he as not on rwy. Plt stated he was confused by taxiway marking & he believes taxiway arrows are misleading.NTSB CHI85LA349Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Bay City, MIThe acft was damaged during a hard forced landing following a loss of pwr shortly after takeoff. The plt reported that at an alt of aprx 250 ft AGL, the eng quit. Post accident inspection revealed the fuel selector was positioned on the right tank which…NTSB CHI85FA351Accident · 1 fatalField investigationFinal reportCessna 404 · South Lyon, MIThe acft took off and climbed to 5000 ft uneventfully. It then dropped off radar and subsequently impacted the ground in a flat upright attitude. A post-crash fire consumed the majority of the airframe. Eng and prop teardowns indicated no abnormalities and…NTSB BFO85LIA01Accident · No injuriesFinal reportCessna U206 · Leesburg, VAThe acft was on a round-robin x-country flt from Leesburg to manassas, VA, gaithersburg, MD & return to Leesburg. When the plt departed gaithersburg on the final leg of the flt, he estimated he had 11 gal of fuel. He reported that during arrival at Leesburg,…NTSB ATL85IA251Incident · No injuriesIncident investigationFinal reportCessna 441 · Hilton Head, SCThe pilot reported that the approach sequence and profile were normal, and there were no apparent aircraft problems. After touch down the pilot applied reverse thrust. During the landing roll out, the aircraft veered off the left side of the runway, collided…NTSB LAX85LA357Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, AZThe acft ran off the rwy and into a ditch after a landing at Glendale, AZ. The rwy is 2400 ft long and 50 ft wide. The plt stated he landed about 40% down the rwy, bounced three times, steered off the rwy and hit a shallow ditch. The plt reported no…NTSB LAX85LA349Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Santa Paula, CAOn a local flt to view camping and hiking facilities in mountainous terrain, the acft entered a box canyon with a moderately rising floor and steep sides reported by the sheriff's department at about one-quarter of a mile wide. Duringan attempted course…NTSB LAX85LA348Accident · No injuriesLimited investigationFinal reportCessna A188B · Willcox, AZOn August 15, 1985, a Cessna 180 lost eng pwr due to fuel exhaustion and collided with the ground during an aerial applicaion maneuver. The acft sustained substantial damage but the pilot was not injured. The plt stated that he should have checked the fuel…NTSB FTW85LA323Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Floydada, TXThe plt stated he failed to see a metal stand pipe in the cotton field. The acft collided with the stand pipe and flipped inverted. Residue of the spraying chemical was observed on the windscreen after the accident. This residue restricted forward visibility…