NTSB investigations, IN
35 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 2001 | 3 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 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\" = 'IN' AND c.\"eventCountry\" = 'USA'
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" = 'IN' AND c."eventCountry" = 'USA' 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 CHI07LA252Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Knox, INThe in-flight encounter with turbulence.NTSB CHI06LA074Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Chesterfield, INThe pilot's failure to maintain aircraft control after becoming spatially disorientated shortly after departure. Contributing to the accident was the pilot's inadequate preflight weather evaluation, his inadvertent flight into night instrument meteorological…NTSB CHI05LA135Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · New Chicago, INThe inadvertent encounter with convectively induced turbulence (CIT) while the aircraft was descending into the terminal area.NTSB CHI05LA065Accident · 1 fatalLimited investigationFinal reportRamsey RV-8A · Rochester, INThe pilot failed to obtain a preflight weather briefing for his destination airport and he initiated the flight into known adverse weather conditions at the departure airport. The pilot subsequently failed to maintain adequate altitude while circling the…NTSB CHI01LA154Accident · Serious injuriesLimited investigationFinal reportBoeing B757-200 · Kokomo, INthe turbulence encountered during descent and the passenger failure to return to his seat.NTSB CHI01LA120Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Culver, INthe wrong runway selected by the pilot which resulted in a tailwind landing condition. Factors to the accident were the tailwind, the wet runway, the reduced braking action, and the airport perimeter fence.NTSB CHI01FA064Accident · 2 fatalField investigationFinal reportCessna 172K · Martinsville, INThe pilots decision not to fly to the alternate airport, his decision to continue the flight in known adverse weather conditions, spatial disorientation by the pilot, and his failure to maintain aircraft control. Factors were the low ceilings, the dark night,…NTSB CHI98FA107Accident · 4 fatalField investigationFinal reportBeech A-36 · New Lebanon, INThe pilot's flight into known icing conditions. Contributing factors were the degraded aircraft performance, the pilot's inability to maintain the proper descent rate, trees, and the dark night condition.NTSB CHI98FA099Accident · 1 fatalField investigationFinal reportCessna T210L · Orleans, INThe pilot's attempted VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance with trees. Contributing factors were the pilot's impairment from prescription drugs, low ceilings, fog, trees, and hilly terrain.NTSB CHI98FA031Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Lynn, INthe pilot's failure to maintain control of the airplane which resulted in the inflight separation of the wings, vertical stabilizer/rudder, and the stabilator. Factors associated with the accident the pilot continued the flight into known adverse weather and…NTSB CHI96FA284Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Muncie, INthe inadvertent flight of the airplane by the pilot-in-command into a thunderstorm. The weather was a factor.NTSB CHI96LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Valparaiso, INthe pilot's continued flight into adverse weather. Factors were the low ceilings, icing conditions, airframe ice, and the muddy field.NTSB FTW94LA229Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · South Bend, INThe encounter with unforcasted and unreported turbulence.NTSB CHI93FA137Accident · 2 fatalField investigationFinal reportCessna 177B · Rensselaer, INThe pilot-in-command's failure to maintain aircraft control. Factors were fog and drizzle, and the pilot-in-command's continuing VFR flight into IMC conditions.NTSB CHI90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Wayne, INThe failure of the pilot of the accident airplane to maintain sufficient speed for flight. The pilots lack of total experience and the crosswinds that were present during the approach and the attempted go-around are contributing factors to the accident.NTSB CHI89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Logansport, INPoor judgement of the pilot due to physical impairment from consumption of alcohol, his inadvertent flight into known adverse weather, and his inadequate control of the aircraft during a precautionary landing. Contributing factors were: the weather conditions…NTSB CHI89FA101Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Bristol, INContinued flight by the pilot into known adverse weather and his exceeding the design stress limits of the aircraft, which resulted in failure of the wing spars and separation of the right wing and empennage (stabilizers). Contributing factors were: continued…NTSB CHI89LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Valparaiso, INInadequate preflight preparation by the pilot, which resulted in inadvertent flight in icing conditions and rapid accumulation of airframe ice, and the pilot's failure to maintain sufficient airspeed to flare during the landing. Factors related to the…NTSB CHI89LA001Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Tell City, INThe pilot flew a VOR approach to the airport, but was too high to land on the approach runway. He executed a circling VFR pattern to land on the reciprocal runway, then flew into the ground fog in the descending base turn. The left wing struck a tree while in…NTSB CHI88FA080Accident · 1 fatalField investigationFinal reportCessna 310Q · Servia, INThe pilot induced overload to the airplane structure causing material failure of the airplane. Attempted flight into adverse weather, and spatial disorientation of the pilot, are contributing factors in this accident.NTSB FTW87FA183Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Kokomo, INThe plts preflt wx briefing revealed marginal VFR & IFR wx along his proposed route, with a precaution for thunderstorms. An IFR flt plan was filed and the acft departed. Later during flt the plt was radioed info about a convective SIGMET that contained a…NTSB CHI87DET07Accident · 1 fatalFinal reportMcentee Stitsplaymate SA-11A · Rolling Prairie, INAircraft crashed in open rising field killing pilot and destroying aircraft. Homebuilt aircraft was not ifr-equipped or certified. Pilot had less than ten hours on aircraft. No flight plan filed. No record of weather briefing, or in-flight weather advisory.…NTSB CHI87FA106Accident · Serious injuriesField investigationFinal reportAirbus Industrie A300B4-203 · Indianapolis, INWhile cruising at ngt in clr air (well abv clds), eastern ai lines flt 477 was in light chop at FL 310 with the seat belt sign on. The captain stated that when the turbulence increased to a moderate cond, he made an announcement for the flt attendants (f/a's)…NTSB CHI87FA099Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Attica, INAfter completing a cable patrol flt, the plt landed at sullivan, IN, to refuel before starting a night flt to reposition the acft at lafayette, IN. The plt departed in clear wx. However, as he was arriving at lafayette, he advised the tower controller that…NTSB CHI86FA200Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Shelby, INThe non-instrument rated pilot initiated the VFR flight from wheeling, IL, to madison, IN, IN marginal weather conditions. The wreckage was found on the afternoon of the following day about 26 miles south of gary, IN. The aircraft sustained an in-flight…NTSB CHI86LA144Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia City, INThe pilot had become disoriented and was concerned about his low fuel state when he decided to make a precautionary landing. The weather was deteriorating and it was getting dark although the pilot stated he could distinguish the trees from the ground. He…NTSB CHI85FA157Accident · 4 fatalField investigationFinal reportCessna 210L · Muncie, INThe plt took off at 1125 EST after receiving a wx briefing. While en route, the forecast wx for the destn bcm worse & a SIGMET (1E) was issued. At 1444, the plt contacted ft wayne fss & had his VFR flt plan extndd 1 hr. He neither requestednor received…NTSB CHI85FA153Accident · 1 fatalField investigationFinal reportBeech N35 · La Porte, INThe thousand hour plus instrument rated plt filed IFR into a known area of three and four level thunderstorms. While being drct by ATC it was noted that headings flown were very erratic. When questioned by ATC the pilot replied 'stand by'. Shortly afterward…NTSB CHI85LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, INThe non-instrument rated plt made a forced landing in a muddy fld due to a low fuel state and IFR conditions. The acft nosed over upon touchdown. There was no record found of the plt having received a wx briefing.NTSB CHI84FA342Accident · 1 fatalField investigationFinal reportPiper PA28-140E · Montmorenci, INThe acft crashed while on a x-country personal transportation flt. Prior to departure, the plt telephoned a relative at the destination, 118 miles away, & had been informed that the flt conditions (wx) at brazil were good. The plt did not obtain a wx briefing…NTSB CHI84FA107Accident · 1 fatalField investigationFinal reportCessna 150D · Wanatah, INAt about 1716 CST, the non-instrument rated plt contacted a fss, reported he was in the clouds with about 1 hr of fuel on board & requested 'vector me someplace.' He was told that indianapolis was VFR, but the plt stated that he could not reach indianapolis &…NTSB CHI84FA027Accident · 2 fatalField investigationFinal reportMooney M20E · Newark, INThe acft had been recently purchased by the plt & this was the 2nd leg of a 3 leg trip which had originally departed hickory, NC. Two witnesses located about 5 mi sse of the accident site observed the acft. One witness stated the visibility was less than 1 mi…NTSB DEN82IA098Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-61 · Near Goshen, INThis aircraft encountered unforecast severe clear air turbulance (cat) while in cruise flight at FL350 Near Goshen, IN. As a result of the encounter, the aircraft entered an uncontrolled descent which was arrested at 31,500 feet. A total of seventeen…NTSB CHI82DA078Accident · No injuriesFinal reportPiper PA-30 · Valparaiso, INThe pilot reported encountering severe icing conditions after he had canceled his IFR flight plan and had the airport in sight. At that point, he felt that the safest alternative was to continue the approach. The approach was flown at 120 mph with no flaps.…NTSB CHI82FA019Accident · 2 fatalField investigationFinal reportCessna T337G · Fort Wayne, INOn 1/31/83 at 2134 CST, the acft departed grand island, NE on an IFR flt plan to toledo, OH, with appx 125 gal of fuel on board. While en route, the plt received updated wx for toledo. At that time, the toledo wx was indefinite 100 ft obscd, vis 1-1/2 mi with…