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 FTW91DRA03Accident · No injuriesFinal reportBronner Skybolt · Alvin, TXThe pilot's failure to maintain terrain clearance. A factor was the pilot's decision to perform a low pass.NTSB LAX91FA251Accident · 1 fatalField investigationFinal reportVarga 2150A · Livermore, CAAn inflight collision with terrain for undetermined reasons.NTSB LAX91LA234Accident · No injuriesLimited investigationFinal reportCessna T-210 · St. Helena, CAThat the pilot executed a poorly planned approach and failed to attain a proper touchdown point and delayed the go-around.NTSB ATL91LA102Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Lake Seminole, GAThe failure of the pilot to maintain clearance from the surface.NTSB ATL91LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Little River, SCThat the pilot dragged the right wing tip on final approach when he failed to control the aircraft. Factors to this accident were: a wind shift below the treetops.NTSB ANC91LA061Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Larsen Bay, AKThe pilot's decision to continue VFR into IMC conditions and failure to maintain proper altitude. Contributing to the accident was the low ceiling and fog.NTSB MIA91LA148Accident · No injuriesLimited investigationFinal reportHughes 269C · Tarpon Springs, FLDelay by the pilot-in-command to apply adequate throttle & collective during transition off a dock for a takeoff over a lake. Contributing to the accident was his lack of total experience in the type operation.NTSB DEN91FA071Accident · 1 fatalField investigationFinal reportCessna 172M · Wray, COThe pilot intentionally buzzing and failure to maintain proper altitude.NTSB BFO91FA049Accident · 1 fatalField investigationFinal reportCessna 172N · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance. Contributing was mountainous terrain, low clouds, and VFR flight into IMC.NTSB SEA91LA105Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Lapwai, IDThe pilot's misjudgment of an aerial application swath run. Factors include a downdraft condition and soft terrain.NTSB FTW91DPG06Accident · No injuriesFinal reportGrumman G-164A · Gillett, ARThe windshiled becoming obscured by aerial application spray and the resultant limited vision from the cockpit.NTSB LAX91LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Catalina Island, CAThe pilot's inadequate altitude and intentional low flying which resulted in the airplane cruising into the water. A contributing factor related to the pilot's poor judgment.NTSB MIA91LA139Accident · 1 fatalLimited investigationFinal reportCessna TU-206G · Gulf Of MexicoAn in flight collision with the water for undetermined reasons.NTSB FTW91DRG02Accident · No injuriesFinal reportCessna 188 · La Feria, TXThe pilot exceeded the proper descent rate.NTSB LAX91LA205Accident · Minor injuriesLimited investigationFinal reportBell 206 · Searchlight, NVCannot be determined in that the helicopter was stolen and the certainty of the resulting damage to the helicopter may have been intentional or accidental.NTSB LAX91LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Fernley, NVThe failure of the pilot to adequately assess the climb performance of the accident airplane due to being under the influence of alcohol.NTSB SEA91FA095Accident · 1 fatalField investigationFinal reportCessna 150H · Sumpter, ORThe pilot's improper inflight planning and decisions and the pilot's VFR flight into IMC conditions.NTSB MIA91LA125Accident · 1 fatalLimited investigationFinal reportRutan Aircraft Factory Vari EZE · Panama City, FLThe pilot-in-command misjudged his altitude while conducting an aerobatic maneuver, resulting in an in flight collision with water.NTSB LAX91LA182Accident · Serious injuriesLimited investigationFinal reportRobinson R22-BETA · Phoenix, AZThe pilot's failure to maintain main rotor RPM. Factor contributing to the accident was the pilot's inadequate in-flight planning.NTSB FTW91LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Port Lavaca, TXThe pilot's inadvertent stall at an altitude too low for recovery. A factor was the pilot's low pass.NTSB SEA91LA087Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Coeur D'Alene, IDThe pilot's misjudgement of his aircraft's climb capability when flying towards rising terrain. Factors include his lack of familiarity with the geographic area.NTSB LAX91LA154Accident · 1 fatalLimited investigationFinal reportMooney M-20E · Lee Vining, CAThe failure of the pilot to maintain adequate altitude to clear mountainous terrain. Contributing to the accident was pilot fatigue due to a lengthy cross country flight.NTSB SEA91LA074Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Friday Harbor, WAThe pilot's failure to maintain a proper climb gradient and rate as a result of his inadequate compensation for wind conditions.NTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.NTSB BFO91LA034Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Buchanan, VAThe pilot's decision to attempt the takeoff with unfavorable winds.NTSB CHI91FA108Accident · 4 fatalField investigationFinal reportPiper PA-30 · Thief River Fls, MNImproper IFR procedure of the pilot, while intercepting the ILS localizer, by not maintianing the minimum descent altitude (mda) for that segment of the approach.NTSB BFO91LA032Accident · No injuriesLimited investigationFinal reportPiper PA32-260 · Roanoke, VAThe pilot's failure to maintain terrain clearance on a night visual approach.NTSB LAX91FA132Accident · 10 fatalField investigationFinal reportHawker Siddeley DH.125-1A/522 · San Diego, CAImproper planning/decision by the pilot, the pilot's failure to maintain proper altitude and clearance over mountainous terrain, and the copilot's failure to adequately monitor the progress of the flight. Factors related to the accident were: insufficient…NTSB FTW91FA049Accident · 2 fatalField investigationFinal reportBeech 36 · New Braunfels, TXThe pilot's disregard for the minimum descent altitude and failure to perform a missed approach. Factors were the pilot's attempt to fly into known adverse weather conditions, low ceiling, rain, and fog.NTSB DEN91FA049Accident · 2 fatalField investigationFinal reportBeech F33A · Sterling, COPoor judgement of the pilot and his misjudgement of altitude while buzzing over glassy water. His lack of visual ques to judge altitude over glassy water was a related factor.NTSB LAX91FA124Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Palm Springs, CAIncapacitation of the pilot due to inadequate sleep.NTSB DEN91FA051Accident · 2 fatalField investigationFinal reportBeech 58 · Whites City, NMThe pilot's inflight decision to fly at low altitude. Factors were: turbulence and downdrafts.NTSB DEN91FA048Accident · 1 fatalField investigationFinal reportCessna T210M · Taos, NMThe pilot's decision to initiate flight into freezing rain which resulted in structural icing that exceeded the ability of the aircraft to maintain flight. A factor was: improper deicing.NTSB DEN91FA042Accident · 4 fatalField investigationFinal reportCessna U206 · Yampa, COInadvertent accelerated stall by the pilot in command while attempting a turn in close proximity to terrain. A factor was the high altitude.NTSB LAX91LA097Accident · No injuriesLimited investigationFinal reportRobinson R22A · Piru, CAFailure of the CFI to maintain main rotor RPM during a demonstrated autorotation.NTSB ANC91LA027Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kivalina, AKThe pilot's failure in not identifying the weather conditions along the route. Contributing to the accident was improper in flight planning and decision by the PIC and the whiteout conditions.NTSB LAX91FA094Accident · 2 fatalField investigationFinal reportBoeing N2S-3 · Sonoma, CAThe pilot-in-command/cfi's performance of a low altitude aerobatic maneuver from which he failed to recover. Factors which contributed to the accident related to the pic's improper inflight decision, poor judgment, and his psychological condition.NTSB ATL91FA052Accident · 4 fatalField investigationFinal reportPiper PA-31-350 · Munford, ALThe pilot attempting visual flight in instrument meteorological conditions below the minimum safe altitude for terrain clearance. Contributing factors were the low ceiling and mountainous terrain.NTSB SEA91FA046Accident · 2 fatalField investigationFinal reportCessna C-172 · Colstrip, MTThe pilot's failure to maintain adequate terrain clearance. Factors relating to the accident were the pilot's lack of total night flight experience, his lack of recent night flight experience, the dark night light conditions, and the mountainous/hilly terrain…NTSB NYC91FA067Accident · 4 fatalField investigationFinal reportMBB BK 117 B-1 · Sonestown, PAThe pilot's inadequate preflight planning to assure that the intended course and altitude provided adequate terrain clearance. Contributing factor(s) was: the dark night, snow and mountainous terrain.NTSB ATL91FA043Accident · 1 fatalField investigationFinal reportCessna 337C · Bryson City, NCThe inadvertent flight into instrument meteorological conditions in mountainous terrain by the noninstrument rated pilot.NTSB ATL91FA042Accident · 1 fatalField investigationFinal reportCessna 310 · Brunswick, GAThe incapacitation of the pilot.NTSB SEA91LA045Accident · No injuriesLimited investigationFinal reportCessna C-150L · Alderwood Manor, WAThe failure of the pilot in command to attain proper clearance from terrain. A factor relating to this accident was the night light conditions.NTSB LAX91LA067Accident · No injuriesLimited investigationFinal reportPiper PA 34-200T · Red Bluff, CAThe failure of the pilot in command to detect a descent below the minimum descent altitude for the approach in use.NTSB SEA91FA262Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Dayville, ORThe pilot's poor in flight decision. Factors include mountainous/hilly terrain.NTSB DEN91LA030Accident · No injuriesLimited investigationFinal reportCessna 206A · Carlsbad, NMA loss of control by the pilot during landing roll due to his failure to maintain directional control.NTSB NYC91DGT01Accident · 1 fatalFinal reportKolb Twin Star · Carlisle, PAThe pilot's failure to maintain adequate altitude above the ground.NTSB ANC91FA018Accident · 1 fatalField investigationFinal reportCessna 208 · False Pass, AKThe pilot's improper decision to continue flight into an area of mountainous terrain and adverse weather conditions. The terrain and weather were factors.NTSB SEA91FA120Accident · 1 fatalField investigationFinal reportCessna 182H · Thompson, UTThe pilot's misjudged descent. Contributing to the accident was the dark night conditions.NTSB ANC91FA017Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Evanston, WYThe pilot's premature descent. Contributing to the accident was the pilot's fatigue and poor weather.