NTSB investigations, 1984
13 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
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\") = 1984
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") = 1984 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 FTW85LA067Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Robert Lee, TXThe acft was on ferry flt with a planned stop at Robert Lee arpt. Prior to touchdown, during the flare, the plt saw 3 OR4 deer in the middle of the runway. He banked to the left and prior to adding power to go-around, the acft settled to the ground next to…NTSB FTW85FA045Accident · 2 fatalField investigationFinal reportde Havilland DHC-1-22 · Abilene, TXAcft crashed while attempting an intentional low level acrobatic maneuver (left roll) over the rwy. Witnesses stated that the acft made a low pass (100-200' AGL) down the rwy & entered the roll. At the inverted position, the nose fell thru, but the maneuver…NTSB MKC84LA279Accident · No injuriesLimited investigationFinal reportCessna 182D · Rolla, MOThe plt tried to 'balloon' over a pack of dogs on the rwy and stalled the acft. The resulting hard landing failed the nose gear and damaged the firewall.NTSB NYC84FA306Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Wilmot, NHWitnesses saw a rt wing section separate when the acft was in a loop. The acft descended and crashed afterwards. The investigation disclosed the pilot had previous aerobatic experience in gliders. No records were disclosed revealing pilot flight time in…NTSB LAX84LA441Accident · No injuriesLimited investigationFinal reportBell P-63C-5-BE · Madera, CAThe plts of a Bell P-63 (king cobra), N62822 & a north American P-51 (mustang), N65206, were participating in an air- show when the acft collided during landing. An investigation revealed the P-63 plt had made a 360 overhead pattern before landing. At about…NTSB NYC84LA285Accident · No injuriesLimited investigationFinal reportNavion Navion · Brodheadsville, PAShortly after takeoff pilot was advised of model aircraft in flight path, evasive action taken, however, presence of model not confirmed. Pilot reduced pwr below recommeded RPM causing aircraft to settle. Pilot then applied pwr to avoid collision with trees.…NTSB FTW84FA372Accident · No injuriesField investigationFinal reportCessna 402 · Dfw Airport, TXAccording to the plt, a rwy change accepted late in the apch required a steep turn and rapid descent. At aprx 400 ft AGL both throttles were advanced but neither eng responsed. The acft landed in unimproived terrain short of the rwy collapsing the left main…NTSB CHI84LA333Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Bloomington, ILPlt departed on local flt shortly before the twr closed. Plt recalled final twr transmission included altimeter setting which was a significant change on his instrument. On return to the arpt, 35 mins after departure, fog and haze had reduced visibility to…NTSB LAX84FA382Accident · 1 fatalField investigationFinal reportEntwicklungsgemeinschaft Phoebus C · Yermo, CAThe pilot encountered adverse soaring flight conditions during a long x-country attempt and was forced to divert to an intermediate airport. On a long glide to his selected landing site, the pilot encountered high powerlines. Turning to avoid them , he lost…NTSB NYC84LA222Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Egg Harbor Town, NJAccording to the pilot at 350 to 400 ft AGL and aprx 85 KTS the acft abruptly pitched nose down. Recovery was attempted but, the pilot related, the flt controls were jammed. Impact occurred in 30 ft deep water about 45 degrees nose down. During recovery the…NTSB NYC84LA219Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Amityville, NYThe acft sustained substantial damage during a step turn maneuver on the water. The student was briefed by the instructor prior to the flight and they proceeded to perform training maneuvers over the water. During the step turn maneuver, the instructor…NTSB ATL84FA184Accident · 1 fatalField investigationFinal reportBeech A36 · Fayette, ALThe acft collided with the ground in a near vertical nose down attitude after being observed by witnesses to pitch down during cruise flt. This acft & plt flew earlier in the day with an instructor who had to recover control of the acft after the plt allowed…NTSB NYC84FA143Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Concord, MAThe acft crashed into a house while on an ILS approach to rwy 11 at hanscom field. Shortly before the acft had reached the outer marker (and after the hand off from boston approach control to hanscom tower) an altitude alert on N4467X was received by the…