NTSB investigations, 2000
10 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\") = 2000
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") = 2000 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 SEA01LA022Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Mercer Island, WAThe pilot's failure to maintain aircraft control during a left turning step taxi to takeoff, resulting in a wing contacting the water during the step turn.NTSB ANC01LA020Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B2 · Girdwood, AKThe pilot's failure to maintain adequate altitude/clearance from terrain. A factor in the accident was flat light conditions.NTSB ANC00MA125Accident · 5 fatalMajor investigationFinal reportPiper PA-31T3 · Nuiqsut, AKThe pilot's failure to extend the landing gear, his improper aborted landing procedure, and inadvertent stall/mush. Factors in the accident were an improper adjustment of the landing gear warning horn system by company maintenance personnel, and the failure…NTSB LAX00LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Payson, AZThe pilot's failure to maintain directional control during the takeoff roll due to over-rotation, inadequate airspeed, and improper remedial action under the high density altitude condition.NTSB ATL00LA086Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Pine Hill, ALThe pilot's failure to adequately preflight the helicopter, which resulted in his failure to remove the tie down.NTSB CHI00LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Marion, INthe pilot failed to maintain directional control during landing. A factor was the dust devil.NTSB CHI00LA230Accident · No injuriesLimited investigationFinal reportBell BH-222-U · St. Paul, MNthe pilot's inadequate preflight and improper vertical takeoff and not obtaining clearance from helicopter pad light. Factors included the tailwind takeoff and the helipad light.NTSB CHI00LA222Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Oshkosh, WIthe pilot failed to maintain control of the airplane during flare/touchdown.NTSB SEA00LA083Accident · No injuriesLimited investigationFinal reportde Havilland U-6A · Kenmore, WAThe pilot's failure to maintain control of the aircraft during the landing roll. Contributing factors were the power wave created by the nearby yacht, the rough water conditions, and the pilot's loss of visual contact with the wave during the rollout.NTSB LAX00LA145Accident · No injuriesLimited investigationFinal reportOwens/Richburg Vans RV6-A · Sacramento, CAFailure to maintain sufficient altitude while on the base to final turn for landing subsequently striking the wing tip on the runway.