NTSB investigations, 1982, SC
8 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 8 |
| 1998 | 2 |
| 1999 | 7 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
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 year(c.\"eventDate\") = 1982
AND 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\" = 353)
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") = 1982 AND 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" = 353) 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 ATL83LA043Accident · No injuriesLimited investigationFinal reportAerosport Champ · Spartanburg, SCThe aircraft collided with trees during a forced landing following an engine failure during climbout after takeoff. The engine developed full power during runup and takeoff. During a left turn to crosswind the engine began to lose power andcontinued to lose…NTSB ATL82FLG15Accident · Serious injuriesFinal reportPiper PA-28-140 · Near Lockhart, SCThe aircraft was flown from charlotte, NC to daytona beach, FL, to sanford, FL without en route refueling. The pilot had previously planned to get fuel at sanford, but after landing there, he thought there sufficient fuel to return to charlotte. However, as…NTSB ATL82FLG14Accident · Serious injuriesFinal reportCessna 182B · Charleston, SCThe flight departed conway, Arkansas for a non-stop flt to Charleston. Approximately 4 to 5 miles from the airport at Charleston, with the runway in sight, the engine quit. The acft struck trees drg a forced landing on a power line right-of-way 2 miles short…NTSB ATL82DA222Accident · Serious injuriesFinal reportBeech C23 · Greer, SCThe student pilot had received about three hours in this make and model of aircraft. After about 45 minutes of dual instruction, he was indorsed for solo flight, the instructor deplaned, and the student took off to fly locally. About 25 minutes later, the…NTSB ATL82DA165Accident · Minor injuriesFinal reportBeech A36 · Myrtle Beach, SCAs the pilot approached his destination, he descended from 9000 ft MSL and leveled at 1600 ft MSL. At about the time he leveled, the engine quit abruptly. He stated that he switched the fuel selector to the right tank and tried to start the engine, but was…NTSB ATL82DA118Accident · No injuriesFinal reportPiper PA-18A · Timmonsville, SCThe pilot reported that he reduced power at 1000 ft and applied carburetor heat for an extended glide to the sod strip. While on final approach over a wheat field, the airspeed bled off and he moved the throttle to add power. However, he reported that the…NTSB ATL82DA114Accident · No injuriesFinal reportCessna 172E · Society Hill, SCThe engine quit at 4000 feet and the pilot elected to land in trees rather than a road with traffic. The aircraft ended up on small gravel road with the gear collapsed. No fuel was found in the aircraft.NTSB ATL82DA073Accident · No injuriesFinal reportHiller UH12E · Lydia, SCThe pilot was applying liquid fertilizer on his last swath run prior to reloading when the engine stopped. A run-on landing was attempted during which the skids sank into the soft ground causing the helicopter to roll over. The field was level and covered…