NTSB investigations, NC
7 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1985 | 1 |
|---|---|
| 1986 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1992 | 1 |
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 c.\"eventStateOrRegion\" = 'NC' 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" = 'NC' 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 ATL92LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Boone, NCThe pilot's failure to abort the take off, and his abrupt pull up with insufficient airspeed to continue flight. Factors were the inadequate airspeed and the inadvertent stall.NTSB ATL89LA154Accident · 1 fatalLimited investigationFinal reportBoeing E75 (PT-13D) · Jacksonville, NCThe pilot encountered an accelerated stall during an abrupt maneuver, lost control of the airplane and did not have sufficient altitude to recover from the ensuing spin prior to colliding with the ground.NTSB ATL87LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Sylva, NCThe CFI instructed his low-time beginning student to make a normal appch to the rwy, and fly down the rwy at about 10 ft above the rwy surface while maintaining rwy hdg. The CFI stated that the purpose of the maneuver was '...to help the student improve his…NTSB ATL87FA088Accident · 3 fatalField investigationFinal reportBeech C23 · Semora, NCWhile conducting a local aircraft checkout, the aircraft was observed flying low prior to pulling up to avoid colliding with a utility line crossing the intended flt path. The aircraft crashed into an open field in a nose low vertical attitude. The post…NTSB ATL87FA045Accident · 2 fatalField investigationFinal reportCessna 170B · Asheville, NCDuring initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student…NTSB ATL86FMG08Accident · 1 fatalFinal reportH. Preiss HP-19C · Boone, NCThe glider made a steep nose high turn, stalled and crashed after a premature tow release at aprx 150 ft AGL. Witnesses said that the glider appeared to be badly controlled from the beginning of the takeoff roll. After the stall during the turn the acft…NTSB ATL85FA147Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Monroe, NCThe acft collided with rwy 23 (aprx 120 ft from the departure end) following a loss of control during an initial takeoff climb. The acft was observed to enter a steep climb on takeoff after which the right wing dropped. The acft then entered a spin prior to…