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 LAX96LA019Accident · Serious injuriesLimited investigationFinal reportEaa Chapter 163 Breezy RLU-1A · Henderson, NVthe pilot's failure to maintain a proper cruise altitude and his inadequate in-flight planning. Contributing factors were encountering rising terrain and a downdraft.NTSB LAX96LA012Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lost Hills, CAthe pilot misjudged the aircraft's altitude.NTSB CHI96LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Crawfordsville, INThe pilot's premature raising of the flaps and the low airspeed.NTSB NYC96FA002Accident · 2 fatalField investigationFinal reportCessna 172N · Caton, NYThe pilot's improper IFR procedure by failing to maintain proper altitude, while on the initial approach for an ILS. A factor relating to the accident was: failure of the tower controller to issue a safety advisory.NTSB CHI95LA335Accident · Minor injuriesLimited investigationFinal reportBell 206B · Indianapolis, INThe pilot not maintaining adequate terrain clearance during his maneuvering exercise and his abrupt lowering of the collective. A factor associated with the accident was the pilot's lack of experience.NTSB SEA95LA224Accident · 1 fatalLimited investigationFinal reportMacphee Vans RV-6 · Jacksonville, ORthe pilot-in-command's failure to maintain altitude and/or clearance from surrounding terrain after a low pass. The mountainous terrain was a factor.NTSB SEA95LA223Accident · 2 fatalLimited investigationFinal reportEurocopter AS350BA · Crater Lake, ORFailure of the pilot to maintain sufficient altitude/clearance above water, while performing low altitude flight. Factors relating to the accident were: the glassy water condition, and lack of visual cues concerning perception of altitude.NTSB LAX95FA339Accident · 1 fatalField investigationFinal reportBell 206L-1 · Irvine, CAthe pilot's intentional VFR flight into IMC conditions and failure to maintain an adequate terrain clearance altitude, and the local controller's improper use of ATC procedure/technique. Factors in the accident were the helicopter's low fuel state and lack of…NTSB LAX95FA338Accident · Minor injuriesField investigationFinal reportSwearingen SA-226T · Chino, CAThe pilot's improper IFR procedure by not initiating a missed approach at the outer marker, by attempting to intercept the glideslope from above after passing the outer marker, and by allowing the airplane to continue descending after reaching the decision…NTSB ATL95LA168Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Minter City, MSInadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the excessive gross weight of the airplane and the high outside air temperature, which would have reduced the performance of the airplane.NTSB SEA95FA214Accident · 3 fatalField investigationFinal reportAgusta A109A II · Winslow, WAthe pilot failed to maintain sufficient altitude/clearance above the surface of water, while flying over calm water conditions at night. Factors relating to the accident were: darkness, low ceiling, fog, glassy (calm) water conditions, and the lack of visual…NTSB ANC95LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKFailure of the pilot to maintain adequate altitude/clearance from terrain, during a low pass over a prospective (off-airport) landing area. Factors relating to the accident were: rain and rising/uneven terrain.NTSB ANC95LA162Accident · No injuriesLimited investigationFinal reportCessna 140 · Anchorage, AKfailure of the pilot to maintain sufficient altitude/clearance from terrain during a low pass over a prospective (off-airport) landing area. Factors relating to the accident were: the 'flat' lighting condition, and uneven terrain.NTSB SEA95FA209Accident · 1 fatalField investigationFinal reportCessna 180J · Browning, MTClearance from the ground was not maintained while attempting a VFR flight into IMC weather conditions. A factor to the accident was fog.NTSB ANC95LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Igiugig, AKThe pilot's inadequate preflight planning/preparation to assure the airplane would maintain adequate altitude/clearance from the river bank during takeoff.NTSB CHI95FA301Accident · 1 fatalField investigationFinal reportKiesel Easy Varieze · Dwight, ILinadequate preflight planning by the pilot. A factor associated with this accident was the pilot did not perform an aborted takeoff is sufficient time to safely stop.NTSB ANC95LA158Accident · 1 fatalLimited investigationFinal reportShort Brothers SC-7 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions. The weather was a factor.NTSB FTW95LA361Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Holyoke, COthe pilot's failure to maintain terrain clearance.NTSB ANC95FA150Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's improper in-flight planning and decision by flying into a box canyon.NTSB ANC95FA169Accident · 1 fatalField investigationFinal reportPiper PA-18A · Anchorage, AKThe pilot's improper in-flight planning/decision and failure to maintain adequate clearance or altitude from the mountainous terrain, while maneuvering near an airstrip.NTSB ANC95FA157Accident · 1 fatalField investigationFinal reportPiper L-21A · Kaktovik, AKThe pilot's failure to maintain adequate altitude/clearance from mountainous terrain.NTSB NYC95TA190Accident · Minor injuriesFinal reportSchweizer 269C · Baltimore, MDThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the ground.NTSB LAX95LA293Accident · No injuriesLimited investigationFinal reportPitts S-2B · Phoenix, AZThe inadequate supervision by the instructor pilot by allowing the trainee to initiate a late go-around from a simulated forced landing.NTSB MIA95LA201Accident · No injuriesLimited investigationFinal reportCessna 150L · Opa Locka, FLThe pilot-in-command's improper use of flaps during an attempted go-around.NTSB LAX95LA285Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-B · Peoria, AZthe pilot's improper inflight decision to attempt a tail wind landing to a short runway.NTSB MIA95FA207Accident · 1 fatalField investigationFinal reportCessna 210C · Dawsonville, GAThe pilot's disregard of the weather forecast and flight into known adverse weather (instrument flight conditions), resulting in an in-flight collision while maneuvering in mountainous terrain. Contributing to the accident was the pilot's lack of recent…NTSB FTW95LA332Accident · 1 fatalLimited investigationFinal reportCessna A188B · Fort Necessity, LAThe pilot's failure to maintain terrain clearance. A factor relating to the accident was: the gusty wind conditions.NTSB SEA95FA171Accident · 2 fatalField investigationFinal reportCessna 172M · Quilcene, WAThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain clearance from the mountains. Factors in the accident were the clouds and mountainous terrain.NTSB ANC95FA129Accident · 2 fatalField investigationFinal reportCessna 170 · Coldfoot, AKThe pilot's failure to maintain adequate distance and/or altitude from terrain. Rising mountainous terrain and downdrafts associated with unfavorable wind conditions were factors in the accident.NTSB ANC95LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Circle, AKThe pilot's premature liftoff during takeoff.NTSB NYC95LA209Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Frankfort, NYInflight collision with the ground for undetermined reasons.NTSB CHI95LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kingman, KSthe pilot's failure to obtain sufficient airspeed before liftoff, and his delay in aborting the takeoff. A factor relating to the accident was: the pilot's lack of recent flying experience.NTSB CHI95LA244Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Morris, MNthe pilot failed to maintain obstacle clearance.NTSB SEA95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wellsville, UTThe pilot's failure to maintain airspeed. Factors in the accident were the pilot's lack of experience with flying in mountainous terrain and the high density altitude.NTSB ANC95LA125Accident · No injuriesLimited investigationFinal reportCessna 207 · Shishmaref, AKThe pilot's failure to adequately compensate for the downdraft. Factors associated with the accident were: the short, uphill runway, and downdrafts.NTSB CHI95LA232Accident · Serious injuriesLimited investigationFinal reportPZL-Mielec M-18A · Carrington, NDthe pilot's inadequate preflight planning/preparation. Factors relating to the accident were: the airplane's excessive gross weight, and the unfavorable wind conditions.NTSB SEA95LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakeview, ORthe pilot's failure to maintain clearance with terrain while his attention was directed to reading his map. The pilot's intentional low-altitude operation of the aircraft contributed to the accident.NTSB LAX95LA261Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Huron, CAFailure of the pilot to maintain sufficient altitude above the ground after diverting his attention to read a map. Factors relating to the accident were: darkness, which reduced the pilot's visual cues concerning outside references while reading the map; and…NTSB LAX95LA257Accident · 1 fatalLimited investigationFinal reportCessna TU206 · Danville, CAThe pilot's intentional flight into known adverse weather and failure to maintain proper altitude.NTSB NYC95FA162Accident · 1 fatalField investigationFinal reportCessna 140 · Danielsville, PAThe flight crew's improper in-flight planning/decision, and failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors relating to the accident were: darkness, fog, low clouds, and the high terrain.NTSB FTW95LA304Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Stratton, COThe pilot's excessive rate of descent as he initiated the swath run and operation of the aircraft over the maximum allowable gross weight.NTSB CHI95LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot's failure to maintain altitude and/or clearance at the beginning of the spray run. A factor was turbulence due to the different Air temperatures of adjoining terrain.NTSB LAX95FA243Accident · 1 fatalField investigationFinal reportCessna 152 · Miramar, CAThe pilot's failure to maintain proper altitude (or clearance) above the terrain, while attempting to perform VFR flight in instrument meteorological conditions (IMC). Factors relating to the accident were: darkness and the adverse weather conditions.NTSB FTW95LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Elaine, ARThe pilot did not maintain a positive rate of climb.NTSB ANC95FA101Accident · 6 fatalField investigationFinal reportPiper PA-32R-300 · Haines, AKThe pilot's failure to maintain an adequate altitude above and clearance from the surrounding terrain. A factor related to the accident was the pilot's improper decision to conduct the maneuver in such close proximity to the rising terrain.NTSB ANC95FA095Accident · 1 fatalField investigationFinal reportPiper PA-18 · Nulato, AKThe pilot's failure to maintain adequate airspeed and clearance (altitude) above the water, while maneuvering at low altitude. A factor related to the accident was: the pilot's improper decision to allow a passenger to accompany the flight without a seat belt.NTSB ATL95FA128Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe pilot's failure to follow proper IFR procedures by descending below the decision height. Factors relating to the accident were the weather conditions and the dark night.NTSB SEA95FA136Accident · 1 fatalField investigationFinal reportAlon Aircoupe A-2 · Cody, WYThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course. A factor was the downdrafts encountered in the mountainous terrain.NTSB FTW95LA267Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX7-77 · Santa Fe, NMThe pilot's improper planning for the high wind landing. Factors were the unfavorable winds and the tree stump.NTSB SEA95LA135Accident · No injuriesLimited investigationFinal reportCessna 172L · Stanley, IDThe pilot's failure to use all available runway, his improper use of flaps, and his failure to maintain airspeed. A factor contributing to the accident is high density altitude.