NTSB investigations, 1992
121 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 244 |
|---|---|
| 1983 | 255 |
| 1984 | 241 |
| 1985 | 209 |
| 1986 | 207 |
| 1987 | 176 |
| 1988 | 158 |
| 1989 | 187 |
| 1990 | 154 |
| 1991 | 143 |
| 1992 | 121 |
| 1993 | 98 |
| 1994 | 74 |
| 1995 | 114 |
| 1996 | 110 |
| 1997 | 94 |
| 1998 | 110 |
| 1999 | 101 |
| 2000 | 99 |
| 2001 | 75 |
| 2002 | 85 |
| 2003 | 122 |
| 2004 | 115 |
| 2005 | 100 |
| 2006 | 87 |
| 2007 | 88 |
Where
Latest cases
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 year(c.\"eventDate\") = 1992
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240)
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 year(c."eventDate") = 1992 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240) 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 LAX93FA086Accident · 2 fatalField investigationFinal reportRockwell 690B · Herlong, CAAn inadvertent encounter with severe turbulence which exceeded the design strength of the airplane's structure.NTSB DEN93FA021Accident · 3 fatalField investigationFinal reportCessna 210 · Aurora, COCollision with terrain when the pilot inadvertently flew into fog while conducting a visual approach. Factors were: inaccurate weather evaluation by the pilot and lack of familiarity with the geographic area.NTSB FTW93FA055Accident · 2 fatalField investigationFinal reportMooney M20C · Deridder, LAThe pilot's loss of control of the airplane in IMC. A factor was his lack of recent instrument flight experience.NTSB DEN93FA017Accident · 1 fatalField investigationFinal reportRockwell 690C · Golden, COThe pilot flying the aircraft beyond the design maneuvering speed and exceeding the design stress limits. A factor was: clear air turbulence.NTSB SEA93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Moran Junction, WYThe pilot in command's attempting flight into known adverse weather conditions and his subsequent inability to maintain altitude. Factors contributing to the accident were icing conditions and trees.NTSB DEN93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to evaluate changing weather conditions.NTSB CHI93FA054Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Gaylord, MIThe pilot-in-command exceeded the airplane's design stress limits.NTSB CHI93FA053Accident · 1 fatalField investigationFinal reportPiper PA-30 · Bowman, NDThe non instrument rated private pilot's failure to maintain adequate terrain clearance after inadvertent VFR flight into instrument meteorological conditions.NTSB SEA93FA033Accident · 1 fatalField investigationFinal reportBeech 35-33 · Riverton, UTTerrain clearance was not maintained. Factors to the accident were: snow and flight into known adverse weather.NTSB DEN93FA015Accident · No injuriesField investigationFinal reportDouglas DC-8-52 · Denver, COAn encounter with severe clear air turbulence.NTSB MIA93FA025Accident · 1 fatalField investigationFinal reportCessna 152 · Ocala, FLThe pilot-in-command becoming lost and disoriented and his failure to maintain altitude.NTSB CHI93LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Frankfort, ILFailure of the pilot in command to maintain an airspeed above stall during a landing flare.NTSB LAX93LA056Accident · 2 fatalLimited investigationFinal reportCessna 182K · Flagstaff, AZThe pilot's continued flight into instrument meteorological conditions and improper remedial action by descending into high terrain. Contributing to this accident were the prevailing cloud condition.NTSB FTW93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Washington, OKThe pilot's failure to maintain proper clearance over the fence.NTSB CHI93LA041Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Mccook, NEThe pilot's improper decision to depart in known adverse weather conditions. The icing conditions and structural ice were factors.NTSB SEA93FA026Accident · 6 fatalField investigationFinal reportBeech A60 · Snoqualmie Pass, WAFailure of the pilot to maintain control of the aircraft, his failure to prevent the aircraft from exceeding the never exceed speed (vne), and subsequent exceeding of the design stress limits of the aircraft. Factors related to the accident were: weather…NTSB DEN93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Kersey, COInadvertent stall and loss of control due to structural icing. Factors were: icing conditions, and flight into known adverse weather.NTSB ATL93FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Blairsville, GAThe pilot's decision to continue the flight into adverse weather conditions which resulted in the inflight collision with high terrain. Factors were high wind and rain.NTSB FTW93FA039Accident · 1 fatalField investigationFinal reportCessna 172M · Snook, TXThe pilot's intentional flight into instrument meteorological conditions as a result of his alcoholic and drug impairment of efficiency and judgement. Factors contributing to the accident were: the pilot's failure to obtain weather information, the dark night…NTSB BFO93FA005Accident · 3 fatalField investigationFinal reportCessna 177B · War, WVVFR flight by the pilot into instrument meteorological conditions, his failure to maintain control of the airplane due to spatial disorientation, and the pilot allowing the design stress limits of the aircraft to be exceeded. Factors related to the accident…NTSB FTW93LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Jayton, TXThe pilot failed to maintain flying speed while maneuvering for landing and allowed the a/c to stall. Factors were the low ceilings, the pilots disregard of the forecast weather, the carburetor icing conditions, and the pilots delayed application of…NTSB ANC93FA013Accident · 3 fatalField investigationFinal reportCessna 402C · Kiana, AKThe pilot in command's attempt to fly VFR into IMC conditions. Factors were snow, whiteout conditions, and mountainous terrain.NTSB SEA93FA018Accident · 2 fatalField investigationFinal reportMaule M5 · Challis, IDThe pilot continued the VFR flight into IMC weather conditions. Factors relating to the accident were the snow and obscuration weather conditions, inadequate preflt planning/preparation by the pilot in command, and the mountainous terrain.NTSB LAX93LA031Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Mokuleia, HIThe flight's encounter with unforecasted unfavorable winds (loss of thermal lift) and downdrafts while on final approach to the runway.NTSB SEA93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Evanston, WYThe pilot's disregard of hazardous weather advisory, resulting in flt into forecast icing conditions in an acft not equipped or certified for the flt, and the improper inflt planning by pilot during the VFR approach that resulted in impact with terrain short…NTSB LAX93LA027Accident · No injuriesLimited investigationFinal reportBeech 36TC · Sedona, AZThe pilot's poorly planned approach and delay in executing the appropriate remedial action. Contributing to this accident was the pilot's failure to maintain the proper glidepath and encountering a downdraft.NTSB SEA93LA017Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Green River, UTThe inadequate preflt planning/preparation by the pilot resulting in inflt encounter with weather and his failure to maintain proper rate of descent during an emergency forced landing. A factor relating to the accident was the turbulent weather conditions.NTSB CHI93FA024Accident · 2 fatalField investigationFinal reportCessna U206F · Valentine, NEThe pilot-in-command's intentional flight into an area of low ceilings, and his failure to maintain an altitude sufficient for terrain clearance. Factors which contributed to the accident were: the pilot's overconfidence, the low ceiling and the dark night…NTSB LAX93LA022Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX7-77 · Sierra Vista, AZThe flight's encounter with unforecast unfavorable winds.NTSB BFO93LA002Accident · No injuriesLimited investigationFinal reportBeech B24R · Waynesburg, PAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from the terrain/obstructions. Factors related to the accident were the pilot's lack of a preflight weather briefing, and the…NTSB SEA93LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Lind, WAThe aircraft encountered rough terrain during the landing roll after the pilot elected to perform a precautionary landing in an open field, due to deteriorating weather.NTSB NYC93FA028Accident · 2 fatalField investigationFinal reportBeech A36 · Middlebourne, WVThe pilot's decision to intentionally fly into known icing conditions which resulted in an inadvertent stall and uncontrolled descent into trees. A factor related to the accident was the icing conditions.NTSB ANC93FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Talkeetna, AKThe pilot's continued visual flight into instrument meteorological conditions at night which resulted in a loss of airplane control, spatial disorientation, and an inflight breakup. Factors which contributed to the accident were: the adverse weather and the…NTSB LAX93LA008Accident · No injuriesLimited investigationFinal reportCessna R172K · Picacho, AZThe pilot's encounter with the unforecasted cyclonic wind.NTSB ANC93LA006Accident · No injuriesLimited investigationFinal reportCessna 150F · Denali, AKThe inadequate preflight planning and preparation by the student pilot, the student pilot's continued flight into known adverse weather and the pilot's failure to maintain directional control on the roadway landing. Factors relating to the accident were: the…NTSB MIA93LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St Augustine, FLFailure of the instructor pilot (CFI) to assure adequate compensation for wind conditions. Factors related to the accident were: the crosswind and turbulent weather conditions.NTSB ANC92LA181Accident · No injuriesLimited investigationFinal reportCessna 185 · Petersburg, AKThe pilots inadequate compensation for wind during initial climb. A factor relating to accident was the gusty wind condition.NTSB MIA92LA191Accident · Serious injuriesLimited investigationFinal reportLet L-13 · New Smyrna Bch, FLThe pilot's inadequate compensation for wind conditions. The downdraft was a factor in the accident.NTSB ATL92FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Samantha, ALThe pilot's inadequate preflight planning and preparation, his lack of expereince, which resulted in an encounter with instrument weather conditions during an attempted visual flight, and his subsequent spatial disorientation. Factors were the dark night…NTSB CHI92LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Baldwin, WISpatial disorientation as the pilot attempted visual flight procedures in instrument meteorological conditions.NTSB CHI92FA280Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pullman, MIThe pilot in command's exceeding the design stress limits of the aircraft.NTSB MIA92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · New Hope, FLPoor in-flight planning and decision and failure of the pilot to maintain aircraft control.NTSB BFO92FA133Accident · 2 fatalField investigationFinal reportCessna 182R · Westerly, RIInadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, self-induced pressure…NTSB BFO92LA126Accident · 1 fatalLimited investigationFinal reportCessna 172E · Tuckahoe, NJVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the light conditions at dusk (or darkness), and the pilot's lack…NTSB ATL92LA172Accident · No injuriesLimited investigationFinal reportAyres S-2R · Douglas, GAThe pilot's failure to check weather prior to the flight. A factor was the dark night.NTSB LAX92LA373Accident · No injuriesLimited investigationFinal reportCessna 170A · Holtville, CAThe pilot's encounter with the unforecasted dust devil.NTSB ANC92FA141Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKPilot in command's intentional flight into known adverse weather conditions. Factors relating to the accident were: the pilot's disregard for adverse weather advisory, weather conditions (clouds) and mountainous terrain.NTSB DEN92FA085Accident · 3 fatalField investigationFinal reportPiper PA-32-301T · Kit Carson, COThe pilot becoming spatially disoriented and exceeding the design stress limits of the aircraft. Factors were: the pilot's failure to obtain a weather briefing, his attempted VFR flight into a level six thunderstorm, and his lack of instrument time.NTSB ATL92LA159Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Guntersville, ALThe pilot's inadequate evaluation of the in flight weather conditions, and his subsequent loss of aircraft control, which resulted in the design stress limits of the aircraft being exceeded. Factors were clouds, the associated turbulence, and the hail in the…NTSB NYC92FA153Accident · 2 fatalField investigationFinal reportDanny M Damron Long EZ · Front Royal, VAThe pilot's self induced pressure to complete the flight which resulted in intentional flight into IMC conditions, and a collision with trees. Factors related to the accident were the pilot's over confidence in his abilities, and the low clouds and fog which…