NTSB investigations
3,485 cases where the first occurrence was “In flight collision 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\" = 230) 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" = 230) 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 CHI94LA349Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Williamsport, INThe continued flight into adverse weather conditions, the student's failure to maintain a proper glideslope and the CFI's delay in initiating remedial action. Factors related to the accident were the lightning and turbulent thunderstorm conditions.NTSB SEA94FA245Accident · 2 fatalField investigationFinal reportCessna A185E · Juneau, AKAttempted VFR flight into IMC. Factors to the accident were: clouds and mountainous terrain.NTSB LAX94FA372Accident · Minor injuriesField investigationFinal reportHughes 369D · Genoa, NVThe pilot/operator's operation of the helicopter with a disconnected throttle on the right collective; the FAA inspector's inadequate preflight/pretakeoff checks of the flight control/throttle systems; and the pilot/operator's failure to adequately inform the…NTSB LAX94LA386Accident · 2 fatalLimited investigationFinal reportBell 47G-5 · Pacific Ocean (Pacific Ocean)an in-flight collision with the water for undetermined reasons.NTSB SEA94FA247Accident · 1 fatalField investigationFinal reportCessna 150J · Roseburg, ORthe pilot's failure to maintain clearance from the terrain.NTSB SEA94LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Paradise, WAProper altitude was not maintained and improper inflight planning/decision. Factors to the accident were mountainous/hilly terrain conditions and lack of total experience.NTSB ANC94FA130Accident · 1 fatalField investigationFinal reportPiper PA-18 · Gulkana, AKThe pilot's failure to maintain clearance from terrain.NTSB SEA94LA228Accident · Minor injuriesLimited investigationFinal reportSikorsky S-64F · Libby, MTThe flight crew allowed the helicopter's weight and balance to be exceeded, and the external load (tank) jettison system failed to operate. A factor related to the accident was: the false indication on the retardant quantity indicator.NTSB ANC94LA110Accident · No injuriesLimited investigationFinal reportBell B-206 · Gustavus, AKThe pilot misjudged his distance/altitude from the landing area, and his lack of recent night flying experience. Factors which contributed to the accident were: the pilot's failure to assure that he would be landing with sufficient light, and the dusk/dark…NTSB FTW94LA280Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Trinidad, COThe pilot's failure to maintain terrain clearance.NTSB SEA94FA225Accident · 2 fatalField investigationFinal reportCessna 172K · Laramie, WYThe pilot's failure to maintain clearance from terrain. Downdraft wind on the lee side of the ridgeline was a factor.NTSB FTW94LA277Accident · No injuriesLimited investigationFinal reportHodges P-51-51 · Beaumont, TXThe improper adjustment of the propeller system pitch.NTSB ANC94LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Northway, AKThe pilot's inadequate evaluation of the weather and his failure to maintain visual lookout during the maneuver. Factors were the low ceilings and obscuration.NTSB ANC94LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chickaloon, AKThe pilot's inadequate in-flight planning and a failure to maintain directional control of the airplane. Factors were the rising, rough/uneven terrain and the tailwind.NTSB FTW94FA272Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Van Horn, TXThe uncorrected descent by the pilot. A factor was the lack of total experience in type aircraft.NTSB SEA94LA210Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G-109B · Rock Springs, WYAircraft control was not maintained. Factors to the accident were: high density altitude and wind gusts.NTSB BFO94FA134Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Grand Lake Strm, METhe pilot attempted a maneuver at an altitude insufficient for recovery. A factor in the accident was pilot physical impairment due to alcohol consumption.NTSB ANC94FA105Accident · 3 fatalField investigationFinal reportDe Havilland DHC-2 · Port Alsworth, AKImproper in-flight planning/decision by the pilot, and his failure to remain clear of mountainous terrain. The box/blind canyon and proximity of mountainous terrain were related factors.NTSB ANC94FA100Accident · 6 fatalField investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot of the VFR only flight intentionally entered instrument meteorological conditions. Factors in the accident were the inadequate procedures/directives by the company/operator management concerning continued VFR flight in marginal weather conditions…NTSB MIA94LA191Accident · No injuriesLimited investigationFinal reportAyres S2R · Ruleville, MSThe pilot-in-command's misjudgement of his altitude while maneuvering on an aerial application/swath run, resulting in an in-flight collision with terrain and subsequent nose over.NTSB NYC94FA145Accident · 1 fatalField investigationFinal reportCessna 210N · Martinsburg, WVFailure of the pilot to maintain adequate altitude and proper climb during the missed approach. Factors related to the accident were: darkness, fog, and conditions conducive to pilot fatigue.NTSB SEA94LA202Accident · 1 fatalLimited investigationFinal reportGroce Vans RV-4 · Glendive, MTAirspeed was not maintained after takeoff. A factor was high density altitude.NTSB CHI94LA259Accident · No injuriesLimited investigationFinal reportStugart Vans RV-6 · Carthage, MOfailure of the pilot to maintain directional control during landing and unsuitable terrain encountered during the landing roll.NTSB SEA94GA203Accident · 1 fatalFinal reportHughes OH-6A · Duchesne, UTThe pilot's improper in-flight planning/decision and failure to maintain sufficient altitude/clearance from the surrounding terrain. Factors related to the accident were: thunderstorms in the area (requiring the pilot to deviate from the desired course), high…NTSB SEA94LA201Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18S · Royal City, WAThe pilot's inadequate remedial action. Factors include high density altitude and unfavorable winds.NTSB SEA94FA194Accident · 2 fatalField investigationFinal reportHughes 369HS · Seaside, ORInflight collision with terrain for undetermined reasons.NTSB SEA94FA190Accident · 1 fatalField investigationFinal reportBell 206B III · Syracuse, UTUndeterminedNTSB NYC94FA134Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Minford, OHThe pilot's failure to follow the published instrument departure procedure. A factor in the accident were the weather conditions.NTSB LAX94LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Murphy Springs, IDThe pilot's improper in-flight decision to maneuver in a canyon at such low altitude that he could not out climb the adjacent rising terrain.NTSB CHI94LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Tribune, KSthe pilot's failure to maintain clearance above the corn crop during the swath run.NTSB ANC94FA087Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Mccarthy, AKThe pilot's inadvertent use of the parking brake during the takeoff and not aborting the takeoff. A factor in the accident was the pilot's improper use of the airplane checklist.NTSB CHI94LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kankakee, ILThe pilot's poor preflight planning preparation by the improper loading of the airplane.NTSB SEA94LA177Accident · Serious injuriesLimited investigationFinal reportDay Teeny II · Colville, WAThe pilot's failure to maintain altitude sufficient to clear terrain. The downdraft was a factor.NTSB ANC94FA080Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Portage Creek, AKThe pilot's inadequate preflight planning and preparation, and his failure to ensure that the airplane was within its gross weight and center-of-gravity limits, which resulted in an inability to obtain sufficient airspeed for sustained flight and a resultant…NTSB FTW94FA224Accident · 2 fatalField investigationFinal reportAerospatiale AS 350B-2 · Granite, COFailure of the pilot to assure main rotor clearance from sloping terrain while in a hover. The terrain condition was a related factor.NTSB SEA94LA175Accident · Minor injuriesLimited investigationFinal reportPezetel M-18 Dromader · Plymouth, WAThe rudder being jammed in almost the full left position.NTSB CHI94LA226Accident · 2 fatalLimited investigationFinal reportCessna T210M · Beaver Island, MISpatial disorientation of the pilot-in-command due to flight into known instrument meteorological conditions; factors in the accident were the fog and low ceiling.NTSB SEA94FA164Accident · 1 fatalField investigationFinal reportCessna 185C · Palouse, WAThe inadvertent disorientation of the pilot after entering instrument meteorological conditions. Fog was a related factor.NTSB FTW94FA220Accident · 2 fatalField investigationFinal reportSIAI-Marchetti F.260 · Dover, OKFailure of the pilot to maintain adequate altitude while performing an aerobatic demonstration. Factors related to the accident were: the pilot's inadequate training, his lack of experience in the type of operation, and insufficient FAA oversight of this type…NTSB SEA94FA167Accident · 2 fatalField investigationFinal reportBeech P35 · Cedar City, UTThe pilot's failure to maintain a proper climb rate and clearance from the terrain. Factors in the accident were the high density altitude and the aircraft being above the maximum certificated gross weight.NTSB SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.NTSB DCA94MA065Accident · 37 fatalClass 1 · MajorFinal reportDouglas DC-9-31 · Charlotte, NC1) The flightcrew's decision to continue an approach into severe convective activity that was conducive to a microburst; 2) the flightcrew's failure to recognize a windshear situation in a timely manner; 3)the flightcrew's failure to establish and maintain…NTSB SEA94LA165Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccall, IDThe pilot's inadequate preflight planning and attempted operation which exceeded the performance capability of the airplane. Factors include his overconfidence in the aircraft's ability.NTSB CHI94LA218Accident · No injuriesLimited investigationFinal reportCallair A9B · Minot, NDthe pilot's failure to maintain clearance from the wheat field. A factor was the turbulence.NTSB MIA94LA165Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Sarasota, FLAltitude misjudged by the pilot.NTSB DCA94MA061Accident · 12 fatalClass 1 · MajorFinal reportLearjet 25D · Chantilly, VAThe poor decisionmaking, poor airmanship, and relative inexperience of the captain in initiating and continuing an unstabilized instrument approach that led to a descent below the authorized altitude without visual contact with the runway environment.…NTSB BFO94FA104Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Warren Grove, NJThe pilot disregarded weather evaluations, attempted VFR flight into IMC and failed to maintain altitude and clearance from the terrain.NTSB SEA94LA150Accident · Serious injuriesLimited investigationFinal reportSchell RV-6A · Crowheart, WYThe pilot in command's failure to maintain adequate altitude. A factor was downdraft conditions.NTSB BFO94FA103Accident · 3 fatalField investigationFinal reportBeech A-36 · Brainerd, MNThe pilot's failure to follow the published missed approach procedure, and his failure to obtain and/or maintain adequate altitude to avoid collision with the terrain. Factors in the accident were: the pilot's lack of instrument flying experience, and the…NTSB BFO94LA097Accident · 1 fatalLimited investigationFinal reportFalen Commander 503 · Georgetown, OHThe gyroplane's uncontrolled descent into terrain due to undetermined reasons.