NTSB investigations, 1992
9 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 19 |
| 1985 | 16 |
| 1986 | 12 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 13 |
| 1990 | 7 |
| 1991 | 22 |
| 1992 | 9 |
| 1993 | 11 |
| 1994 | 15 |
| 1995 | 21 |
| 1996 | 10 |
| 1997 | 9 |
| 1998 | 14 |
| 1999 | 9 |
| 2000 | 10 |
| 2001 | 10 |
| 2002 | 9 |
| 2003 | 9 |
| 2004 | 9 |
| 2005 | 11 |
| 2006 | 5 |
| 2007 | 7 |
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 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\" = 160)
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" = 160) 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 MIA93LA027Accident · Minor injuriesLimited investigationFinal reportBell 47-G5A · Belle Glade, FLThe improper in flight decision of the pilot in command to attempt an agricultural turn with insufficient altitude to accomplish the maneuver. Contributing to the accident was the pilot's overconfidence in his abilities.NTSB ANC92LA183Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Fairbanks, AKThe pilot's preflight planning/preparation in accessing the available runway length and snow conditions. Factors relating to the accident were the snow bank and the pilot in command's lack of familiarity with skiplane operations.NTSB ANC92LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Lime Village, AKThe pilot in command not maintaining control of the airplane. A factor in the accident was the wind gusts.NTSB SEA92LA199Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bucoda, WAThe failure of the pilot to maintain proper alignment while landing on water, resulting in a swerve during deceleration.NTSB CHI92FA219Accident · 1 fatalField investigationFinal reportTeal TSC-1A2 · Oshkosh, WIThe pilot-in-command's not following procedures/directives.NTSB SEA92FA160Accident · 1 fatalField investigationFinal reportCessna 172P · Kingston, WAThe pilot's attempt to conduct VFR flight in instrument meteorological conditions. Factors include fog and low ceilings.NTSB ANC92LA090Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-500D · Polk Inlet, AKThe pilot's failure to follow proper procedure and the company's inadequate procedures and directives. A factor was the uneven terrain.NTSB ANC92LA088Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elephant Lake, AKThe dual student's inadequate compensation for wind conditions and the instructor's inadequate supervision. A factor was the tailwind.NTSB LAX92LA193Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Coolidge, AZThe pilot's use of unsuitable terrain and inadequate compensation for the existing wind conditions.