NTSB investigations, 1982
5 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 19 |
| 1986 | 27 |
| 1987 | 25 |
| 1988 | 19 |
| 1989 | 10 |
| 1990 | 14 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 13 |
| 1994 | 9 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 9 |
| 1998 | 11 |
| 1999 | 5 |
| 2000 | 10 |
| 2001 | 10 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 4 |
| 2005 | 12 |
| 2006 | 4 |
| 2007 | 4 |
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\") = 1982
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\" = 100)
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") = 1982 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" = 100) 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 NYC82DA200Accident · Minor injuriesFinal reportBellanca 7GCAA · Coltsneck, NJThe pilot missed a banner pick-up, pulled up abruptly and leveled off at about 350 feet. The aircraft engine lost power and the pilot lowered the nose while in a right turn in an attempt to return to the airport. He stated that engine power was restored while…NTSB CHI82DEG03Accident · Serious injuriesFinal reportBenson B8M · Hamilton, OHThe gyrocopter pilot initiated a takeoff from the grass media between the taxiway and runway 29. After lifting off, he climbed to an altitude of about 40 to 50 ft, then turned toward the runway. At about the same time, a Piper PA-28 was taking off on the…NTSB LAX82DA193Accident · Serious injuriesFinal reportCessna A188 · Ehrenberg, AZThe pilot stated that as he pulled up at the end of a trim run in order to miss some electric wires the aircraft began to shutter. It then rolled left, right, and back to the left going almost inverted before coming to rest in a cotton field.NTSB MIA82DA085Accident · No injuriesFinal reportPiper PA-38-112 · Jasper, FLWhile on a cable inspection mission at 500 ft MSL, the engine began to lose power after the pilot had made an erratic maneuver to avoid birds. He initiated emergency procedures to restore power, but was unable. The nose gear failed and the aircraft flipped…NTSB CHI82DA065Accident · No injuriesFinal reportPiper PA-38-112 · Elyria, OHDuring the landing flare the student overcorrected with full aft elevator. The aircraft pitched up, the instructor applied full power, and the aircraft bounced and drifted into a snow bank. The instructor was reported to have about 20 hours instructing.