NTSB investigations
244 cases where the first occurrence was “On ground/water encounter with weather”.
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\" = 330) 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" = 330) 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 DEN99LA172Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Telluride, COAn encounter with a sudden tailwind gust windshift during landing roll, resulting in an inadvertent ground loop.NTSB ANC99LA156Accident · No injuriesLimited investigationFinal reportStinson 108 · Sparrevohn, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were a gusting crosswind, and high vegetation.NTSB ANC99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were a crosswind, and wind gusts.NTSB ANC99LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor was a crosswind, and an inadvertent ground loop.NTSB DEN99LA135Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe unforecasted sudden wind change, and the pilot's failure to maintain aircraft control. A factor was the down sloping terrain next to the runway.NTSB ANC99LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Sheldon Point, AKThe pilot's inadequate compensation for the gusty crosswind conditions during takeoff. Factors associated with the accident were a crosswind, and wind gusts.NTSB SEA99LA091Accident · No injuriesLimited investigationFinal reportCessna 180G · Kalispell, MTAn encounter with a crosswind gust, which was not possible to compensate for.NTSB ANC99LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ekwok, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were a crosswind, and an inadvertent ground loop.NTSB DEN99LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fort Collins, COThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.NTSB ANC99LA049Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Haines, AKThe pilot's inadequate compensation for the gusty crosswind conditions.NTSB ANC99LA038Accident · No injuriesLimited investigationFinal reportCessna 170B · Mccarthy, AKThe pilot's failure to abort the takeoff in a timely manner. Factors associated with the accident were a tailwind, the pilot's inadequate weather evaluation, and the pilot's premature liftoff.NTSB ATL99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Laurens, SCThe pilot's disregard for current wind conditions and his failure to maintain directional control during landing. Factors were the tailwind and wet runway surface.NTSB DEN99LA050Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Santa Rosa, NMThe unfavorable wind gust which inverted the airplane while taxiing.NTSB LAX99LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe CFI's loss of airplane control upon encountering a dust devil due to his improper in-flight decision to land in proximity to the observed adverse weather conditions.NTSB IAD99LA027Accident · No injuriesLimited investigationFinal reportCessna 421B · Youngstown, OHThe pilot's failure to maintain aircraft control. A factor was the icy runway.NTSB ANC99LA006Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A · English Bay, AKThe pilot-in-command's inadequate compensation for the crosswind conditions, and failure to maintain adequate clearance from the parked airplane. Factors associated with this accident were the gusty crosswinds, and the congested takeoff area due to no parking…NTSB ANC99LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind, and loose gavel.NTSB ANC98LA076Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilots misjudgement of the tailwind, and excessive application of brakes during the off airport landing.NTSB FTW98LA214Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Salt Lake City, UTThe pilot's inadequate compensation for winds while taxing. A factor was gusty, high wind conditions.NTSB FTW98LA133Accident · No injuriesLimited investigationFinal reportCessna 172D · El Paso, TXThe pilots improper compensation for the wind conditions and his failure to maintain control of the aircraft. A factor was the high wind condition.NTSB MIA98LA080Accident · No injuriesLimited investigationFinal reportCessna 172H · St. Petersburg, FLa sudden encounter with wind gusts associated with a quickly passing rain shower which resulted in a nose-over, and subsequent collision with the runway.NTSB FTW98LA003Accident · No injuriesLimited investigationFinal reportCessna 172A · Grand Junction, COEncounter with high gusting winds while standing with the engine runningNTSB LAX97LA231Accident · Minor injuriesLimited investigationFinal reportCessna P206B · Desert Center, CAThe pilot's unexpected encounter with dust devils during the takeoff ground roll.NTSB ANC97LA073Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Togiak, AKfailure of the pilot to properly compensate for crosswind conditions. The crosswind was a related factor.NTSB ANC97LA064Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dillingahm, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident were the wind gusts and crosswind.NTSB ANC97LA062Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Koyuk, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident were the winds gusts and crosswind.NTSB LAX97LA083Accident · No injuriesLimited investigationFinal reportCessna 182H · Burbank, CAthe pilot's improper planning/decision concerning landing and taxiing in high wind conditions. Factors relating to the accident were: the unfavorable wind conditions, and the lack of crosswind limit information in the Cessna 182H Pilot's Operating Handbook…NTSB ANC96LA168Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKthe pilot's inadequate compensation for wind conditions. The gusty wind was a related factor.NTSB ANC96LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Fairbanks, AKThe pilot's inadequate compensation for gusty wind conditions during the landing roll. A factor associated with the accident is the gusty wind conditions.NTSB ANC96LA100Accident · No injuriesLimited investigationFinal reportHorton Avid Flyer MK IV · Tenakee Springs, AKThe pilot's inadequate compensation for wind conditions. Gusty winds were a factor in the accident.NTSB FTW96IA210Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Dallas, TXfailure of the pilot to maintain directional control and runway alignment, during the landing roll out. Factors relating to the incident were: darkness, the adverse weather condition, the wet runway, and reduced visibility due to the inadvertent encounter…NTSB IAD96LA066Accident · No injuriesLimited investigationFinal reportCessna 208 · Washington, DCThe pilot's failure to maintain control of the aircraft while taxiing for takeoff. Related factors were the wet runway and the gusty crosswind.NTSB ANC96LA056Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were the crosswind and the pilot's inadequate evaluation of the wind condition.NTSB ANC96LA025Accident · No injuriesLimited investigationFinal reportCessna 206 · Kotzebue, AKThe pilot's poor judgment in conducting the flight in the existing high gusting wind conditions. A factor associated with the accident was the operator allowing/dispatching the accident flight in the prevailing weather conditions, and the icy ramp/taxi area.NTSB FTW95LA323Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-88 · Mesquite, TXThe pilot's inadequate weather evaluation and the crewmember's failure to hold onto the basket. A factor was the high wind.NTSB SEA95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idaho Falls, IDThe pilot's inadequate airspeed at liftoff. Contributing to the accident were high density altitude, tailwind conditions, the pilot's selection of an excessive takeoff flap setting, and a windshear encounter.NTSB FTW95LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-180 · Westcliffe, COThe loss of control due to the encounter with the dust devil.NTSB MIA95LA050Accident · Serious injuriesLimited investigationFinal reportBeech 95-C55 · Arcadia, FLPoor in flight planning/decision by the pilot for electing to land with fog on the airstrip. Contributing to the accident was failure of the pilot to obtain a formal preflight weather briefing and his failure to fully apply the brakes (normal) after landing.…NTSB NYC95LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Niagra Falls, NYThe pilot's inadequate weather evaluation and the on ground encounter with gusty winds.NTSB MIA95LA020Accident · No injuriesLimited investigationFinal reportCessna 182-D · Deland, FLThe failure of the pilot to compensate for the gusty wind conditions during taxi for takeoff.NTSB MIA94LA150Accident · No injuriesLimited investigationFinal reportMooney M20-J · Apalachicola, FLThe pilot's inadequate compensation for the crosswind resulting in not maintaining alignment with the runway and the pilot's delay in aborting the landing. The crosswind was a factor.NTSB ATL94LA066Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chamblee, GAThe pilot's failure to compensate for the wind condition during landing. A factor is a tailwind.NTSB DCA94IA032Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Chantilly, VAThe flightcrew's failure to maintain directional control during a rejected takeoff. Contributing factors were the wet and icy runway.NTSB SEA93LA190Accident · No injuriesLimited investigationFinal reportCessna 182L · Idaho Falls, IDThe encounter with unfavorable wind during landing roll and the pilot's failure to maintain directional control.NTSB FTW93LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hondo, TXThe pilot's improper evaluation of the weather which led to the downwind takeoff. Factors were the windshift and the tailwind.NTSB FTW93LA182Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ozona, TXThe pilot's failure to correctly compensate for wind conditions. A factor was the unexpected encounter with the crosswind.NTSB MIA93LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · La Belle, FLThe pilot in commands failure to correct for wind conditions during landing rollout resulting in the aircraft flipping over during wind gust encounter.NTSB MIA93LA087Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa-Locka, FLFailure of the pilot-in-command to perform weight and balance calculations, exceeding the gross weight of the airplane, and disregarding wind information provided by the tower controller.NTSB ATL93FA004Accident · 1 fatalField investigationFinal reportAero Commander 680 · Headland, ALThe pilot's failure to maintain control of the airplane while conducting a high speed taxi maneuver which resulted in inadvertent flight. Factors were the pilot's over confidence in his ability, his lack of familiarity with the airplane and the wind gust.NTSB NYC92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Coatesville, PAThe pilot's decision to continue the approach and eventual touching down off the runway which resulted in a loss of control of the airplane and collapsing the landing gear. A factor in this accident was the pilot's loss of visual perception and fog.