NTSB investigations, NE
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 WHERE c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA' 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 WHERE c."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA' 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 MKC82DA083Accident · Minor injuriesFinal reportCessna 150 · Chadron, NEAfter flying 1.2 hours with an instructor pilot the student pilot was released for solo flight. The student then flew for .7 hours before running out of fuel. The aircraft nosed over after touching down in a pasture. The instructor pilot stated that the fuel…NTSB MKC82DA089Accident · No injuriesFinal reportPiper PA-38-112 · Scottsbluff, NEThe pilot stated that during an approach for a touch and go landing, at an altitude of about 50 feet above the runway the aircraft began to drop. He applied throttle and the engine hesitated, failing to accelerate until just before impact with the runway. The…NTSB MKC82DA081Accident · No injuriesFinal reportCessna 182A · Minden, NEThe pilot stated that he carried extra power during the approach for aid in directional control in the 10 to 15 knot crosswind. Although the pilot applied full brakes at touchdown on the wet sod runway, the aircraft ran off the end into a ditch.NTSB MKC82DA078Accident · Serious injuriesFinal reportCessna T210N · Near O'Neill, NEThe aircraft landed successfully at centerville, IA on its first leg of the flight. The aircraft was not refueled and the pilot estimated 4 hrs fuel on board for a 2 hr and 40 minute flight. The flight made 4 missed approaches before proceeding to an…NTSB MKC82DA077Accident · No injuriesFinal reportMaule M-4 · Cozad, NEThe aircraft was landed on runway 31 with a 20 degree quartering headwind from the right at 10 gusting 15 knots. During landing, the aircraft veered to the left and the pilot applied right rudder. However, the aircraft continued into a ground loop and was…NTSB MKC82DA072Accident · No injuriesFinal reportPiper PA-18 · North Loup, NEThe pilot stated that the aircraft broke ground about 1000 feet down the runway but would not climb. The pilot attempted to jettison the load but did not have time. The aircraft was landed in rough terrain. Investigation revealed that the aircraft was below…NTSB MKC82DA063Accident · No injuriesFinal reportCessna 150 · Potter, NEThe student pilot was on his first flight to the "bar j lazy v" ranch. He saw a group of buildings which he believed to be on the ranch. Nearby was a field that appeared to have been bladed to remove grass clumps. He proceeded to make a full flap landing on…NTSB MKC82DA054Accident · No injuriesFinal reportCessna 340A · Lincoln, NEThe pilot tookoff from runway 17L at 1705 CST. After takeoff, he encountered a vibration. He decided to land and was cleared for runway 14. Reportedly, the vibration increased at 130 knots. The pilot reduced the power to decrease his speed and remain under…NTSB MKC82DA052Accident · No injuriesFinal reportCessna 182RG · Gurley, NEDuring takeoff from a wheatfield the left gear hit a rut and the pilot lost control. The takeoff was aborted and the aircraft traveled across a road and through a fence.NTSB MKC82DA053Accident · Minor injuriesFinal reportCessna 205 · Hebron, NEAfter landing on runway 30 the pilot stated that he initiated a turn to taxi to his parking space when a gust of wind lifted the tail of the aircraft into the air and it nosed over. Winds were gusting to 35 knots.NTSB MKC82FCJ02Accident · 1 fatalFinal reportPiper PA-28-140 · Davenport, NEAt 1242 CST, the pilot received a weather briefing including a forecast of marginal VFR conditions at the destination. Between 1649 and 1848 CST, there were three weather reports from the destination of ceilings between 300 and 500 ft, visibilities between…NTSB MKC82DA050Accident · No injuriesFinal reportCessna 150L · Omaha, NEDuring a maximum angle climb after lift-off, the aircraft stalled while climbing through about 200 to 300 ft AGL. The pilot stated that he lowered the nose to obtain a faster airspeed. However, he believed that the plane descended into diminishing headwinds…NTSB MKC82DCJ01Accident · Serious injuriesFinal reportPiper PA-22-150 · Alliance, NEAfter landing and dropping off one passenger the pilot attempted to takeoff. The airport manager stated that due to the unusually warm weather the frost was out of the ground and the runway had many gopher mounds which were very soft. He further stated that…NTSB MKC82DA015Accident · No injuriesClosedSwearingen SA227 · Lincoln, NENTSB MKC82FA010Accident · No injuriesClosedCessna 402C · Mccook, NENTSB MKC82FA007Accident · 5 fatalClosedCessna 182P · Wauneta, NENTSB MKC81DCJ34Accident · No injuriesClosedPiper PA-38 · Kearney, NENTSB MKC81FCJ33Accident · Serious injuriesClosedRutan Vreze · Lincoln, NENTSB MKC81DCJ32Accident · No injuriesClosedPiper PA-28 · Ericson, NENTSB MKC81DCJ31Accident · No injuriesClosedGulf-Schwzr G-164B · Lamar, NENTSB MKC81DCJ27Accident · No injuriesClosedPiper PA-25 · Lodgepole, NENTSB MKC81FCJ29Accident · No injuriesClosedPiper PA-25 · Cairo, NENTSB MKC82DCJ30Accident · No injuriesClosedPiper PA-28 · Humboldt, NENTSB MKC81DCJ28Accident · No injuriesClosedCessna A188B · Riverton, NENTSB MKC81DCJ25Accident · Serious injuriesClosedGrumman G-164B · Ewing, NENTSB MKC81DCJ24Accident · No injuriesClosedCessna A188B · Arapahoe, NENTSB MKC81DCJ26Accident · No injuriesClosedCessna 188 · Rising City, NENTSB MKC81DCJ23Accident · Minor injuriesClosedTexas Hel OH-13 · Kearney, NENTSB MKC81DCJ22Accident · No injuriesClosedPiper PA-18A · Imperial, NENTSB MKC81DCJ21Accident · No injuriesClosedCessna 172 · Naper, NENTSB MKC81FCJ19Accident · Serious injuriesClosedCessna 188 · Holdrege, NENTSB MKC81DCJ18Accident · Minor injuriesClosedHughes 269C · Union, NENTSB MKC81DCJ20Accident · No injuriesClosedGrumman G-164B · Ravenna, NENTSB MKC81DCJ17Accident · No injuriesClosedCessna 172 · Hastings, NENTSB MKC81FCJ16Accident · 1 fatalClosedPiper PA-25 · Beatrice, NENTSB MKC81FCJ15Accident · 1 fatalClosedCessna 188 · Firth, NENTSB MKC81DCJ14Accident · No injuriesClosedCessna 188 · Chambers, NENTSB MKC81DCJ13Accident · No injuriesClosedCessna 172 · Boelus, NENTSB MKC81DCJ11Accident · No injuriesClosedGrumman G-164A · Miller, NENTSB MKC81DCJ12Accident · No injuriesClosedCessna 152 · Arthur, NENTSB MKC81DCJ10Accident · No injuriesClosedWeatherly 201C · Benkelman, NENTSB MKC81DCJ09Accident · No injuriesClosedNavion G · Bayard, NENTSB MKC81DCJ08Accident · No injuriesClosedSchleicher ASW-19 · Omaha, NENTSB MKC81DCJ07Accident · Minor injuriesClosedCessna 182 · Cody, NENTSB MKC81DCJ06Accident · No injuriesClosedCessna 172 · Omaha, NENTSB MKC81FA018Accident · No injuriesClosedBeech 99 · Grand Island, NENTSB MKC81DCJ05Accident · No injuriesClosedCessna 152 · Omaha, NENTSB MKC81FCJ04Accident · No injuriesClosedCessna 182 · Albion, NENTSB MKC81DCJ03Accident · No injuriesClosedPiper PA-15 · Cambridge, NENTSB MKC81DCJ02Accident · No injuriesClosedCessna 120 · Aurora, NE