NTSB investigations, SC
6 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1995 | 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\" = 'SC' 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\" = 160)
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" = 'SC' 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" = 160) 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 ATL96LA023Accident · No injuriesLimited investigationFinal reportHiller 12C · N. Myrtle Beach, SCThe pilot's improper operation of the flight controls during a practice autorotation, and the certified flight instructor's inadequate supervision of the operationNTSB ATL89LA199Accident · No injuriesLimited investigationFinal reportHughes 269A · Saluda, SCStudent pilot's improper use of the flight controls during lift-off and inadequate supervision by the flight instructor.NTSB ATL88LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Myrtle Beach, SCThe plt was practicing touch and go ldgs on rwy 23 when he lost control of the airplane just after takeoff when it encountered a gust of wind. The rt wing contacted the terrain adjacent to the runway and the airplane flipped over.NTSB ATL86LA117Accident · No injuriesLimited investigationFinal reportBellanca 7-GCAA · Chester, SCAircraft was being repositioned on airport for glider tow. Tow rope was attached and pilot concentrated his attention on avoiding entangling tow rope on runway lights. When pilot noticed the aircraft was too low he attempted a go-around with insufficient…NTSB ATL85LA267Accident · No injuriesLimited investigationFinal reportBryan HP-14 · Aiken, SCPlt reported that sailplane was positioned for a tow in tall grass beside the rwy. He said that during the takeoff the left wing was slowed by the tall grass allowing the right wing to accelerate. The sailplane yawed left and rolled left until 90 degrees to…NTSB ATL84LA204Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Manning, SCThe plt entered a steep turn at the end of a 2nd field that she had selected for a landing. While maneuvering to land, the right wing contacted the ground & the left wing hit a power line. This was the plt's 1st tow & release in this model.