NTSB investigations
1,048 cases where the first occurrence was “On ground/water encounter with terrain/water”.
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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320) 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320) 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 ANC00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were soft, snow covered terrain.NTSB IAD00LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Lyndonville, VTthe student pilot's failure to maintain directional control during landing. A factor in the accident was the ditch that ran parallel to the runway.NTSB ANC00LA026Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site on a frozen, snow-covered lake. A factor associated with the accident was an area of drifted snow at the landing site.NTSB ANC00LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuluksak, AKThe pilot's failure to maintain proper alignment during the takeoff roll. A factor associated with the accident was a soft area of snow on the runway.NTSB MIA00LA077Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · W. Columbia, SCThe inadequate wording of the NOTAM for failure to identify that the usable width of the runway was reduced and the inadequate snow removal by airport personnel for failure to remove the snow from the runway resulting in the on-ground collision with a snow…NTSB MIA00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ocean Reef Club, FLThe failure of the pilot to maintain directional control of the airplane while taxiing after landing resulting in the on-ground collision with high vegetation.NTSB ANC00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Ekuk, AKThe pilot's selection of an unsuitable runway for landing. Factors associated with the accident were the inadequate runway maintenance by the runway maintenance personnel, snow berms, and insufficient runway condition information disseminated by the company…NTSB CHI00LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Plymouth, INthe pilot's disregard of the unsafe runway condition, his decision to operate the airplane on unsuitable terrain, and the failure to maintain runway centerline alignment which resulted in the landing gear contacting deeper snow. Factors associated with the…NTSB ANC00LA020Accident · No injuriesLimited investigationFinal reportCessna 185 · Chenega Bay, AKThe pilot's selection of an unsuitable takeoff area during the incoming tide. Factors associated with the accident were the incoming tide wave, and the pressure induced by the delays encountered picking up the passengers.NTSB NYC00LA053Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Shamokin, PAThe pilot's failure to maintain aircraft control.NTSB NYC00LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Wooster, OHThe pilot's inadvertent taxi onto unsuitable terrain. A factor was the burnt out landing/taxi light.NTSB CHI00LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Raymond, NEthe pilot's lack of recent experience in the type of aircraft and type of operation, and the pilot not maintaining directional control. A finding was the glassy condition of the water.NTSB CHI00FA027Accident · 3 fatalField investigationFinal reportBeech 200 · Chicago, ILOn ground collision with the lake for undetermined reasons.NTSB ANC00LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Glennallen, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident was snow-covered terrain.NTSB IAD00LA001Accident · No injuriesLimited investigationFinal reportCessna 182S · Staatsburg, NYwas the pilot's encounter with an unseen embankment while maneuvering to avoid a deer on the runway.NTSB NYC00LA011Accident · No injuriesLimited investigationFinal reportCessna 172I · N. East Carry, METhe pilot's decision to attempt a takeoff under gusty wind and rough water conditions.NTSB ANC99LA157Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's choice of unsuitable terrain for taxi, and inadequate compensation for high winds. Factors associated with this accident were the muddy ground, and the winds of 25 knots gusting to 40 knots.NTSB FTW99LA260Accident · No injuriesLimited investigationFinal reportCessna 172K · Mountain Home, ARThe pilot's failure to obtain runway alignment. Factors were the dark night conditions, an embankment, and the pilot's lack of total experience flying at night.NTSB ANC99LA144Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Heiden, AKThe pilot's selection of unsuitable terrain for landing.NTSB ANC99LA155Accident · No injuriesLimited investigationFinal reportCessna 182 · Nikolai, AKThe pilot's selection of an unsuitable takeoff and landing area. Factors associated with this accident were the unfavorable winds, and sunglare.NTSB FTW99LA246Accident · No injuriesLimited investigationFinal reportCessna 170A · Brady, TXThe pilot's failure to maintain clearance from a dirt bank.NTSB ANC99LA124Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's selection of an unsuitable takeoff area, and an inadvertent stall. Factors associated with the accident were large wave/swells, and low light conditions (dawn).NTSB SEA99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Yellow Pine, IDMisjudged approach resulting in landing long. Factors include an intentional ground-loop, excessive airspeed and an embankment.NTSB ANC99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Seward, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft sand.NTSB CHI99LA294Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Johnson Creek, WIthe pilot's failure to maintain directional control of the airplane.NTSB ANC99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing. A factor was high vegetation in the landing area.NTSB ANC99LA109Accident · No injuriesLimited investigationFinal reportCessna A188-B · Bettles, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft terrain.NTSB ANC99LA115Accident · No injuriesLimited investigationFinal reportCessna 180 · Sand Point, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was a large rock.NTSB ANC99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Levelock, AKThe pilot's selection of an unsuitable landing site.NTSB CHI99FA263Accident · No injuriesField investigationFinal reportUnderwood Brokaw Bullet · Oshkosh, WIthe pilot failed to maintain directional control of the airplane.NTSB MIA99LA200Accident · No injuriesLimited investigationFinal reportBell OH-13H/M74A · Sparta, GAthe pilot's inadequate preflight which resulting in his failure to remove all the tie downs, and the subsequent impact with the ground.NTSB NYC99LA179Accident · No injuriesLimited investigationFinal reportAllen-Charles Barracuda · Hermon, NYThe pilot's inadequate preflight planning which resulted in a precautionary landing. A factor in this accident was the pilot's selection of unsuitable terrain for the precautionary landing.NTSB NYC99LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mattituck, NYThe pilot's failure to maintain control of the airplane, and the flight instructor's inadequate supervision of the solo flight.NTSB ANC99LA078Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Skwentna, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was high vegetation.NTSB NYC99LA148Accident · No injuriesLimited investigationFinal reportAdams Rotorway EXEC-90 · Evington, VAThe pilot's selection of unsuitable terrain for a run on landing. A factor was the dirt bank.NTSB CHI99LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Traer, IAThe pilot's not maintaining proper runway alignment during the aborted takeoff, and the airport personnel not maintaining the runway. Factors were rough terrain and a dirt bank.NTSB CHI99LA175Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · North Platte, NEThe pilot failed to maintain directional control during takeoff.NTSB ATL99LA100Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbia, SCThe pilot's failure to maintain directional control during a landing roll.NTSB DEN99FA086Accident · 1 fatalField investigationFinal reportPZL-Mielec M-18B · Altus, OKThe pilot's disregard of takeoff performance data and his failure to jettison the load. Contributing factors were high density altitude, exceeding the aircraft's maximum allowable gross weight, and the berm.NTSB FTW99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palacios, TXThe pilot's failure to maintain clearance with terrain. A factor was the high vegetation.NTSB ANC99LA051Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2B-21 · Kongiganak, AKThe deep, water filled hole in the runway.NTSB ANC99LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the soft, snow-covered terrain.NTSB CHI99LA107Accident · No injuriesLimited investigationFinal reportPiper J4A · Howell, MIthe pilot's failure to maintain clearance with the snow covered terrain off the side of the runway while turning the airplane around on the runway. A factor associated with the accident was the snow covered terrain.NTSB NYC99LA075Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Winchester, VAThe pilot's failure to extend the landing gear before landing on the runway.NTSB ANC99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing the wheel equipped airplane. A factor associated with the accident was the soft snow covering the frozen lake.NTSB SEA99LA034Accident · No injuriesLimited investigationFinal reportCessna 182A · Conner, MTThe pilots delayed remedial action during an aborted landing. Factors include a slush-covered runway.NTSB ATL99LA137Accident · No injuriesLimited investigationFinal reportGettis H. Hudson Corban Baby ACE · Pleasant View, TNThe failure of owner of sod runway to properly maintain the runway, the pilots failure to properly preflight the takeoff area before departure.NTSB LAX99LA070Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 Broussard · Minden, NVThe pilot's failure to maintain proper runway alignment during a rejected takeoff. A factor in the accident was the undetermined pitch control/trim system problem, which led to the pilot's rejected takeoff decision and may have distracted him during attempts…NTSB ANC99IA019Incident · No injuriesIncident investigationFinal reportCessna 207 · Kotzebue, AKThe pilot's selection of the wrong taxi route. A factor associated with this incident was the absence of taxiway lighting or marking.NTSB DEN99LA027Accident · No injuriesLimited investigationFinal reportBoeing 727-233 · Denver, COSnow removal not done by other person.