NTSB investigations, 2001, WI
14 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 7 |
| 1984 | 12 |
| 1985 | 9 |
| 1986 | 6 |
| 1987 | 7 |
| 1988 | 4 |
| 1989 | 9 |
| 1990 | 9 |
| 1991 | 3 |
| 1992 | 8 |
| 1993 | 4 |
| 1994 | 7 |
| 1995 | 5 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 3 |
| 1999 | 9 |
| 2000 | 6 |
| 2001 | 14 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 5 |
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\") = 2001
AND c.\"eventStateOrRegion\" = 'WI' 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\" = 250)
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") = 2001 AND c."eventStateOrRegion" = 'WI' 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" = 250) 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 CHI02LA053Accident · No injuriesLimited investigationFinal reportCessna 172L · Reedsburg, WIThe pilot inadvertently released the seat adjustment mechanism which resulted in the seat sliding back during takeoff, and his subsequent failure to maintain control of the airplane. A factor associated with the accident was the runway light control box,…NTSB CHI02LA020Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Middleton, WIthe pilot's improper rotation and failure to maintain directional control during takeoff. Additional factors were the crosswind and the soft terrain.NTSB CHI02LA003Accident · Serious injuriesLimited investigationFinal reportKainz Kitfox IV · Tomahawk, WIThe inadvertent stall/spin encountered by the pilot during a slow flight maneuver. Factors relating to this accident were the low airspeed and the trees.NTSB CHI01LA313Accident · Serious injuriesLimited investigationFinal reportGelasi Aircamper · Bloomfield, WIAircraft control not possible due to the inadvertent control interference by the front seat passenger. Factors to the accident were the restricted control stick movement and the encountered stall.NTSB CHI01FA297Accident · 3 fatalField investigationFinal reportBeech A23 · Stevens Point, WIthe pilot not obtaining/maintaining aircraft control.NTSB CHI01FA247Accident · Minor injuriesField investigationFinal reportBeech C35 · Oshkosh, WIThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB CHI01FA244Accident · 1 fatalField investigationFinal reportSchuchart Stoddard HamiltonSH3 · Oshkosh, WIThe inadvertent stall/spin by the pilot.NTSB CHI01FA235Accident · 1 fatalField investigationFinal reportPayne Giles G-202 · Oshkosh, WIThe pilot failed to maintain aircraft control which resulted in an inadvertant stall. Factors with the accident were the pilot misjudged the approach and the pilot's lack of total experience in the Giles G-202.NTSB CHI01LA227Accident · No injuriesLimited investigationFinal reportMcIlraith Searey Amphibian · La Crosse, WIThe pilot's inadequate compensation for wind conditions and turbulence which resulted in the encountered stall. Factors to the accident were turbulence and the high wind condition.NTSB CHI01LA240Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Plainfield, WIThe pilot not maintaining aircraft control while maneuvering on the aerial application flight. A factor to the accident was the encountered stall/mush at a low altitude.NTSB CHI01LA177Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Kenosha, WIthe inadvertent stall by the pilot. The low altitude was a contributing factor.NTSB CHI01LA157Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Milltown, WIThe stall/mush encountered by the pilot during that takeoff. Factors were the pilot's excessive lowering of the flaps during the takeoff and the trees.NTSB CHI01LA138Accident · 1 fatalLimited investigationFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot allowed the airspeed to get too low and inadvertently stalled the airplane.NTSB CHI01FA117Accident · 1 fatalField investigationFinal reportBeech F35 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed which resulted in a stall. The low altitude was a contributing factor.