# NTSB investigations, SC: Nose over

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ATL93LA020](https://openairdocs.org/ntsb/ATL93LA020.md): Maule M4-210C · Pickens, SC · Accident · No injuries · Limited investigation · Final report · Oct 31, 1992 · N9861M · Substantial damage
  > The pilot's failure to follow normal before takeoff procedures which included placing the propeller lever in the high RPM low pitch position. The pilot also delayed in aborting the takeoff attempt and applied hard braking which resulted in a nose over.
- [NTSB ATL82DA077](https://openairdocs.org/ntsb/ATL82DA077.md): Cessna 152 · Allendale, SC · Accident · No injuries · Final report · Mar 20, 1982 · N757VV · Substantial damage
  > During a solo three hundred mile cross country flight the student pilot stated that he strayed to the south of his intended course. He subsequently became disoriented and after circling an area for about 30 minutes began to panic and elected to land. The…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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" = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=300&state=SC

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.