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 SEA06CA182Accident · No injuriesData collectionFinal reportMaule M-4-180V · Lewistown, MTThe airplane inadvertently impacted a coyote hole during the landing roll on unsuitable terrain.NTSB ANC06CA132Accident · No injuriesData collectionFinal reportPiper PA-12 · Noatak, AKThe pilot's selection of an unsuitable landing site, which resulted in a loss of control during the landing roll and a nose over. Factors associated with the accident were soft terrain and the pilot's failure to maintain directional control.NTSB CHI06CA259Accident · No injuriesData collectionFinal reportLuscombe 8E · Dodgeville, WIThe pilot encountering unsuitable terrain during the precautionary landing. A factor was the ditch the pilot encountered.NTSB DFW06CA206Accident · No injuriesData collectionFinal reportBeech B200 · Hondo, TXThe collision with an unmarked pothole in the taxiway while taxiing for departure. A contributing factor was the obscuration by water.NTSB ANC06LA125Accident · No injuriesLimited investigationFinal reportCessna 206 · Kodiak, AKThe pilot's selection of an unsuitable landing site, which resulted in a rock striking the horizontal stabilizer during the landing roll.NTSB ANC06CA111Accident · No injuriesData collectionFinal reportPiper PA-14 · Fairbanks, AKThe pilot's selection of an unsuitable off-airport site for takeoff, which resulted in an on-ground encounter with rough-uneven terrain, a loss of control, and a collision with small trees. Factors associated with the accident were the uneven terrain, and…NTSB LAX06TA259Accident · No injuriesFinal reportHughes 369D · Lahaina, HIthe pilot's failure to shut down the engine prior to exiting the helicopter resulting in the tail rotor contacting the ground. A contributing factor was the gusting wind conditions present at the accident site.NTSB CHI06CA197Accident · No injuriesData collectionFinal reportCessna 206H · Lutsen, MNThe unsuitable terrain the pilot encountered during takeoff in rough water. A factor was the wave in the rough water.NTSB CHI06FA193Accident · 2 fatalField investigationFinal reportCessna 560 · Cresco, IAThe flight crew's inadequate aeronautical decision-making and poor crew resource management (CRM), including the inadequate use of the on-board sources (such as the flight management system and navigation charts), to get critical information about Ellen…NTSB SEA06CA143Accident · No injuriesData collectionFinal reportRolladen-Schneider LS3A · Enumclaw, WAThe glider pilot's failure to maintain directional control during the landing roll, resulting in the aircraft impacting the dirt embankment on the side of the emergency run-out area. Factors include the pilot's improper decision not to deploy more airbrakes…NTSB ANC06CA085Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing roll, and an on ground encounter with terrain. Factors associated with the accident are the pilot's failure to maintain directional control, and…NTSB ANC06LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor associated with the accident was the rocky terrain.NTSB CHI06CA129Accident · No injuriesData collectionFinal reportPiper PA-30 · Dongola, ILThe pilot's intentional maneuver to avoid obstructions at the end of the runway which resulted in the airplane impacting a ditch. The wet grass runway and the ditch were factors.NTSB ANC06CA050Accident · No injuriesData collectionFinal reportCessna 170B · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor associated with the accident was the snow on the runway.NTSB CHI06CA130Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Brook, INThe pilot's intentional decision to leave the helicopter unattended with the engines running which resulted in a dynamic rollover. The inadvertent dynamic rollover was a factor.NTSB SEA06LA076Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include gusty crosswinds.NTSB NYC06CA087Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. A factor was the gusting winds.NTSB NYC06CA084Accident · No injuriesData collectionFinal reportCessna 180F · Greenville, METhe pilot's failure to maintain directional control during landing, resulting in a ground loop. A factor was the rough/uneven runway condition.NTSB CHI06CA104Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Tower, MNThe unsuitable landing area selected by the pilot which led to the subsequent nose-over. The terrain condition was a factor.NTSB DEN06IA051Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe captain's failure to follow existing company procedures for stabilized approach. **This report was modified on May 23, 2007.**NTSB NYC06IA075Incident · No injuriesIncident investigationFinal reportDassault Falcon 900EX · Teterboro, NJThe co-pilot's failure to obtain the proper touchdown point, which resulted in an overrun. Contributing were the gusty wind conditions, the failure of the flight crew to utilize the air brake after touchdown, and a partially contaminated runway.NTSB ATL06CA034Accident · No injuriesData collectionFinal reportLabarre Hatz CB1 · Walhalla, SCThe pilot's selection of unsuitable terrain to land. Contributing factors were the wet, soft, grassy runway.NTSB SEA06CA034Accident · Minor injuriesData collectionFinal reportCessna 182G · Sweet Home, ORThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the paved runway surface, encountering muddy terrain and nosing over. Contributing factors were the night light condition and the muddy terrain.NTSB CHI06CA052Accident · No injuriesData collectionFinal reportCessna 152 · Pelican Lake, WIThe pilot selecting an unsuitable landing area. Factors were the snow and ice covered lake.NTSB CHI06CA056Accident · Minor injuriesData collectionFinal reportChampion 7EC · Platteville, WIThe student pilot not maintaining directional control during the landing. A factor was the snow bank the pilot encountered.NTSB CHI06CA053Accident · No injuriesData collectionFinal reportCessna 172R · Morris, ILThe pilot's improper in-flight decision to land with a quartering tailwind and not maintaining directional control. Factors were the quartering tailwind and the snowdrift.NTSB CHI06CA049Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Spirit Lake, IAThe pilot using an unsuitable runway and not maintaining directional control during the landing leading to the nose over on impact with snow. A factor was the snow that remained on the runway after plowing.NTSB CHI06CA048Accident · No injuriesData collectionFinal reportCessna T210M · North Lima, OHThe pilot not maintaining airspeed and directional control during the landing. Factors were the snow covered soft terrain the airplane nosed over on.NTSB CHI06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Toronto, OHThe pilot's decision to depart from the snow-covered runway, which resulted in the swerve during takeoff roll and subsequent nose over.NTSB LAX06CA021Accident · Minor injuriesData collectionFinal reportDirks Glaser DG-300 · California City, CAthe pilot's inadvertent retraction of the gear and failure to deploy the spoilers, and his subsequent failure to attain a proper touchdown point.NTSB DFW06CA009Accident · No injuriesData collectionFinal reportVans RV7A · Reklaw, TXThe failure of the nose landing gear assembly for undetermined reasons, resulting in a nose over.NTSB ANC06CA003Accident · No injuriesData collectionFinal reportPiper PA-22 · Willow, AKThe pilot's selection of an unsuitable takeoff area, which resulted in an on ground encounter with a river during an aborted takeoff.NTSB ANC06CA004Accident · No injuriesData collectionFinal reportCessna 206 · Seward, AKThe pilot's inadequate compensation for wind conditions, which resulted in an on ground encounter with terrain, and subsequent loss of control while landing. A factor associated with the accident was a crosswind.NTSB CHI06CA007Accident · No injuriesData collectionFinal reportBeech C23 · Higginsville, MOThe airport operator's failure to properly mark the runway construction project, the exposed lip at the runway end, and the pilot's failure to obtain NOTAM information prior to the flight. A factor was the inadequate marking of the runway.NTSB SEA06CA002Accident · No injuriesData collectionFinal reportBeech D35 · Creswell, ORThe pilot's failure to attain a proper touchdown point and worn brakes. Inadequate maintenance was a factor.NTSB DEN05CA146Accident · No injuriesData collectionFinal reportSchleicher ASW-20B · Moriarty, NMthe pilot's failure to maintain control of the glider during the takeoff roll which resulted in a ground loop.NTSB ANC05CA137Accident · No injuriesData collectionFinal reportdeHavilland DHC-2 · Igiugig, AKThe pilot's delay in aborting the takeoff run when he was unable to lift one float off the water, which resulted in a subsequent collision with terrain. A factor contributing to the accident was a river bank.NTSB ANC05CA134Accident · No injuriesData collectionFinal reportChampion 7KCAB · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor contributing to the accident was a depression/ditch in the landing surface.NTSB CHI05CA248Accident · No injuriesData collectionFinal reportPiper PA-28-180 · McConnell, ILThe pilot's inadequate preflight/planning which resulted in the attempted takeoff on the soft airstrip. Factors associated with the accident were the soft terrain, the corn crop, and the inadequate airspeed achieved during the takeoff roll.NTSB ANC05TA126Accident · No injuriesFinal reportPiper PA-18-150 · Cold Foot, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing down during the landing roll. A factor associated with the accident was the rough and uneven terrain.NTSB SEA05CA168Accident · No injuriesData collectionFinal reportHughes 269A · Ashland, ORThe inability of the dual student to maintain directional control of the helicopter during the landing roll when the left skid sank into an area of thick, soft, sticky tar, and the instructor pilot's improper decision to perform a full-down autorotational…NTSB ANC05LA123Accident · Minor injuriesLimited investigationFinal reportBrabandt RV-9A · Palmer, AKThe loss of nose gear strut/fork-to-ground clearance that led to the collapse of the nose gear strut and nose-over during the landing roll. Factors contributing to the accident were an uneven dirt/gravel surface runway.NTSB ANC05CA119Accident · Minor injuriesData collectionFinal reportCessna 182 · Nabesna, AKThe pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with brush, and subsequent loss of control during an aborted landing. Factors associated with the accident were high vegetation, and a jammed elevator control.NTSB MIA05LA145Accident · Serious injuriesLimited investigationFinal reportFox Alfred C. Kitfox IV 1200 · Immokalee, FLThe pilot's failure to detect standing water on the grass strip resulting in a nose over during the landing roll.NTSB ANC05LA127Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tyonek, AKThe instructor pilot's inadvertent touchdown during a low pass, and attempted go-around, which resulted in an in-flight collision with terrain, and nose over.NTSB ANC05CA113Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's selection of unsuitable terrain for taxi, which resulted in the airplane encountering a ditch, and the collapse of the main landing gear. A factor associated with the accident was the ditch.NTSB ANC05CA109Accident · No injuriesData collectionFinal reportMaule MX7-180 · Yakutat, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a nose-over. A factor contributing to the accident was soft terrain.NTSB ANC05CA099Accident · No injuriesData collectionFinal reportCessna 172 · Akiachak, AKThe pilot's delay in aborting the landing, which resulted in the airplane running off the end of the runway and nosing over. A factor associated with the accident was the rough/uneven terrain off the end of the runway.NTSB SEA05LA141Accident · No injuriesLimited investigationFinal reportCessna 206E · Stuart Island, WAThe pilot's excessive airspeed on final for the current runway surface conditions, and the intentional obstruction avoidance maneuver he executed when it became clear the aircraft was about to go off the end of the runway. Factors include the pilot's improper…NTSB IAD05LA088Accident · No injuriesLimited investigationFinal reportCessna T206H · Vineland, NJThe pilot's inadequate preflight planning, which resulted in his decision to land at a closed airport.