NTSB investigations, 2000, WI
6 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\") = 2000
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") = 2000 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 CHI01FA044Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Milltown, WIThe flight instructor's inadequate supervision of the flight, the flightcrew not maintaining control of the airplane, and the flight instructor's delayed remedial action which resulted in the inadvertent spin. Factors to the accident were the inadvertent spin…NTSB CHI00FA262Accident · 2 fatalField investigationFinal reportBell OH-58C · Watertown, WIThe spatial disorientation by the pilot during continued flight into instrument conditions and the inadequate surveillance by the operator. The inoperative attitude indicator and night conditions were contributing factors.NTSB CHI00FA263Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Watertown, WIAircraft control not being maintained during initial climb resulting in a stall/mush. Factors to the accident were the pilot's inadequate preflight planning/preparation, the pilot operating over the airplane's certified maximum gross weight, and the pilot…NTSB CHI00FA129Accident · 3 fatalField investigationFinal reportCessna 172M · Cornell, WIthe pilot not maintaining aircraft control and the stall/spin he encountered. A factor was the extended flaps.NTSB CHI00LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Neenah, WIthe pilot's inability to flare the airplane during landing and the subsequent loss of directional control due to restricted movement of the control stick. The control stick movement was restricted by the rear seat cushion which was not secured to the…NTSB CHI00LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · East Troy, WIThe proper alignment not being maintained by the dual student during an attempted running takeoff and the inadequate supervision of the pilot-in-command (CFI).