NTSB investigations, NE
3 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1990 | 1 |
|---|---|
| 1993 | 1 |
| 2004 | 1 |
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 c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA' 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 CHI04LA146Accident · 1 fatalLimited investigationFinal reportCessna A188B · Prosser, NEThe pilot's abrupt maneuver to avoid obstructions, and his failure to maintain adequate airspeed resulting in a stall. The low altitude flight operation, and the transmission tower (antenna) were contributing factors.NTSB CHI93MA143Accident · 2 fatalMajor investigationFinal reportBeech C99 · Shelton, NEThe deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…NTSB MKC90DCJ01Accident · 1 fatalFinal reportK. W. Jeffers Varieze · Brainard, NEPilot used poor judgement in attempting aerobatics with inadequate altitude which resulted in loss of aircraft control. Contributing factors were a low pass performed, over confidence in personal ability and ostentatious display by the PIC.