NTSB investigations, IN
4 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1988 | 1 |
|---|---|
| 1993 | 1 |
| 1997 | 1 |
| 1998 | 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\" = 'IN' 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" = 'IN' 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 CHI99LA027Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Monticello, INlow altitude stall and an ostentatious display by the pilot. Factors associated with this accident were the performance of a low altitude maneuver and an abrupt pullup by the pilot.NTSB CHI97LA137Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Paragon, INthe pilot did not maintain aircraft control. The factors involved were aerobatics were performed and improper use of aircraft.NTSB CHI94LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bristol, INthe pilot's abrupt maneuver (intentional swerve) and main gear collapse during the landing roll on a short grass strip.NTSB CHI89DEX01Accident · 1 fatalFinal reportPitts S-15 · Delphi, INFailure to recover from an aerobatic maneuver due to lack of total experience, and lack of recent experience in the type of flight regime.