NTSB investigations, 1983
11 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\") = 1983
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") = 1983 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 LAX84LA115Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC 7-102 · Honolulu, HIWhile on a five mile final apch to rwy 26R the dhc 7 encountered moderate turbulence and two cabin attendants sustained injuries. At 1506:02 hours HST a western airlines DC10 requested an s turn to lose altitude in order land on rwy 26L. Seven seconds later…NTSB NYC83AA209Accident · 5 fatalFinal reportAerospatiale AS350D · Dover Township, NJWitnesses observed the helicopter fly along the beach at alt of about 100-150 MSL, enter a bank to the right and descendinto the water at an angle of about 45 deg. Examination of the wreckage failed to reveal any pre-impact discrepancies of the aircraft or…NTSB ATL83LA292Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Fairfax, SCThe acft mushed into the ground after the engine quit from negative g forces imposed by the pilot after clearing a fenceduring a swath run. After the engine lost power due to the temporary fuel starvation the pilot managed to clear some trees and mush into…NTSB FTW83FA270Accident · 1 fatalField investigationFinal reportAir Tractor AT-400A · Lane City, TXThe plt was leading a flt of 2 acft on an aerial application mission. The plt of the 2nd acft stated that at the end of a swath run, the lead acft pulled up to an almost vertical attitude & to an alt of between 300 & 400 ft AGL. At that time, the plane…NTSB LAX83LA262Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10-10 · Yuma, AZDuring cruise flight the acft experienced a pitch excursion up then down while in autopilot on operation. A cracked strain gage bridge wire was found in the electrical system.NTSB FTW83FA259Accident · 2 fatalField investigationFinal reportCessna 180J · Harvey, LAA navigable waterway, Harvey canal, was being used as a seaplane base. In that area, a set of power lines were suspended over the canal by 2 tall towers. The lowest line over the canal was 160 ft above the canal surface, but the lines dropped to heights of…NTSB FTW83FA251Accident · 1 fatalField investigationFinal reportEnstrom 280C · Opelousas, LAThe helicopter was observed to lift off to a hover and began an erratic hover. The acft pitched up and spun throwing theplt out and fatally injuring him. Witnesses said they did not know the plt was going to fly the helicopter. The opinion was that it was to…NTSB ATL83FA198Accident · 4 fatalField investigationFinal reportBeech V35B · Chesson, ALWhile the acft was on a x-country flt at 4000 ft MSL, radio & radar contact were lost soon after a turn was initiated. Wreckage of the aircraft was found scattered over a distance of 2193 ft. an exam of the wreckage revealed that the stabilizers/ruddervators,…NTSB NYC83FA102Accident · 2 fatalField investigationFinal reportHiller FH-1100 · Gettysburg, PAThe plt took off on a flt to york, PA to refuel the helicopter & to demonstrate it to a prospective buyer while en route. Witnesses observed the helicopter shortly after departure. Two of 4 witnesses heard a change in the sound of the helicopter, 2 witnesses…NTSB DEN83LA096Accident · No injuriesLimited investigationFinal reportCessna 182P · Ashland, MTThe acft lifted off early, stalled, dropped a wing and cartwheeled to a stop. The left main gear was sheared off in the impact. The pilot stated that during the takeoff from his own ranch airstrip a horse ran out on the rwy in front of the acft. He said there…NTSB DEN83FTE05Accident · No injuriesFinal reportSchweizer 1-36 · Colo Springs, COThe glider was substantially damaged during a pullup from a dive at altitude. The wing was rippled and beckled and damaged at the attach points. The dihedrial had changed from 6 degrees to 8.5 degrees. There was also unmeasured change in the sweepback. It is…