Final NTSB investigations, ND
27 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1999 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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 c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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 CHI06FA275Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kulm, NDThe non-instrument rated pilot's continued flight into instrument meteorological conditions which resulted in his inadvertent encounter with a thunderstorm and his loss of aircraft control. A factor to the accident was the thunderstorm.NTSB CHI05LA145Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Mapleton, NDThe pilot's continued flight into instrument meteorological conditions and his failure to maintain clearance from an object during the precautionary landing. The heavy rain and the unknown object were factors.NTSB CHI05LA012Accident · 1 fatalLimited investigationFinal reportCessna 150M · Ashley, NDThe non-instrument rated pilot's continued flight into known adverse weather conditions and his not maintaining aircraft control during cruise flight. Factors present were the night condition and low ceilings.NTSB CHI99FA196Accident · 1 fatalField investigationFinal reportBeech C-23 · Mandan, NDthe pilot failed to maintain aircraft control on approach to the airport after encountering high winds, gusts, rain, and thunderstorms in the area.NTSB CHI98LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Williston, NDthe pilot's inadequate preflight planning/preparation, and his selection of an unsuitable area for landing. The adverse weather condition (low ceiling) and submerged object were related factors.NTSB CHI97LA292Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Grand Forks, NDThe flight attendant's seat belt was not secured. A factor was turbulence in the clouds.NTSB FTW97IA261Incident · Minor injuriesIncident investigationFinal reportBoeing 757-223 · Dickinson, NDan encounter with unforecast convection induced turbulence (CIT). Related factors were: the flight crew's improper evaluation of the weather, and an inaccurate preflight weather briefing by company weather personnel.NTSB CHI97LA036Accident · No injuriesLimited investigationFinal reportCessna 177 · Regan, NDthe pilot's intentional flight into adverse weather. Factors were clouds, the pilot's inadequate in-flight planning/decision making, his poor evaluation of the weather, and the encounter with unsuitable terrain for landing.NTSB CHI96LA259Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Hazelton, NDinadvertent VFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude control of the airplane, which resulted in a collision with the terrain. Factors relating to the accident were:…NTSB CHI95FA285Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ardoch, NDthe pilot-in-command's continuing flight into adverse weather. Factors were the pilot-in-command's failure to obtain a weather observation and the adverse weather.NTSB CHI95LA046Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Dickinson, NDThe flight instructor (CFI) misjudged the flare, which resulted in a hard landing. Factors related to the accident were: the adverse weather (icing) condition, structural ice, windshield ice, darkness, and the lack of visual cues for the pilot to land.NTSB CHI94GA093Accident · 4 fatalFinal reportCessna 401A · Minot, NDFailure of the pilot to maintain proper altitude during a missed approach. Factors related to the accident were: the unfavorable weather and snow covered terrain.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 CHI91DTG01Accident · 1 fatalFinal reportCessna 172P · Bismarck, NDSpatial disorientation. Factors related to the accident are failure to obtain a preflight weather brief, vrf flight into IMC conditions and lack of total experience.NTSB DEN90LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDFailure of the CFI to utilize carburetor heat prior to the induction icing and power loss. Contributing to the accident was the cfi's continued VFR flight into known and forecast instrument meteorological conditions.NTSB DEN88LA146Accident · No injuriesLimited investigationFinal reportCessna 188 · Sentinel Butte, NDThe pilot took off from his private airstrip near Sentinel Butte, ND, en route to beach, ND. He said there was a narrow cloud ahead, approximately 5-8 miles long, and emitting lightning, but it did not appear to him to threaten flight safety. The pilot said…NTSB DEN87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Cavalier, NDThe pilot was landing with a cross wind. The aircraft bounced and drifted into snow bank along the right edge of the runway. The nose gear was broken off in the collision with the snow bank and the engine was pushed into the firewall.NTSB DEN86LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · La Moure, NDAccording to the plt, during a swath run, the acft he was piloting encountered 'bad air' and descended until the wings and wheels contacted the crop of grain he was spraying. The plt stated the acft stalled and contacted the ground.NTSB DEN86FA142Accident · 3 fatalField investigationFinal reportCessna T210N · Elgin, NDPlt received wx briefing prior to departure. VFR flt not recommended by fss. Plt radioed that he was in thunderstorm activity, IFR conditions and was attempting to turn around. Witnesses stated that they observed acft descending at a high rate of speed of a…NTSB DEN85LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · Rocklake, NDThe student plt got lost during her 1st solo x-country flt. She subsequently attempted a lng on a gravel road but swerved the a/c off the road to avoid an oncoming car & the a/c received substantial damage.NTSB DEN85LTG02Accident · 1 fatalFinal reportPiper PA-38-112 · Berthold, NDThe student solo plt was on a cross-country flt and was appropriately endorsed. Impact occurred at aprx 80 degrees nose down. Wx in the vicinity of the accident was reported to be 300 ft ceilings with visibility of 1/4 mi in fog and rain.NTSB DEN84FA085Accident · 1 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe private non-instrument rated plt received two weather briefings before the flight. During the last briefing at 1350 MST, he was informed that VFR flt was not recommended. At 1554 MST, the acft departed crystal arpt in a westerly direction. Several…NTSB DEN84LA020Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, NDThe student plt encountered fog immediately after takeoff at about 150 AGL. The plt looked back & could still see the rwy lights, he then began a descending rt turn to the rwy to land. During this descending turn, the rt wing hit the ground followed by the…NTSB DEN83LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28B-150 · Watford City, NDThe acft nose gear collapsed during a precautionary landing due to weather. The plt had been briefed on the weather the evening before the accident. The pilot stated that when the flight was 20 minutes from home he 'thought we could make it.' However, he…NTSB DEN83LA067Accident · No injuriesLimited investigationFinal reportCessna 150M · Emerado, NDThe acft made a forced landing due to weather which included icing and low ceilings. According to the plt. The acft would no longer hold level flt due to icing and after the acft broke out at 300-350 ft AGL he landed and the gear collapsed. The plt had…NTSB DEN83LA054Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Jamestown, NDWhile en route, the plt encountered freezing rain and climbed to aprx 3500 ft to be on top of all weather. When he throttled back, the engine began surging and would not produce enough power for level flight. The pilot knew that the ground level in that area…NTSB DEN82FA062Accident · 2 fatalField investigationFinal reportBellanca 14-19-3A · Selfridge, NDOn the previous day the plt received a wx briefing for the flt. He was advised the wx would be marginal VFR in the bismarck area in the morning due to low ceilings & snow. There is no record that the plt received an updated wx briefingprior to departure. The…