NTSB investigations, MS
4 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1999 | 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\" = 'MS' 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"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" = 'MS' 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
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 MIA99LA266Accident · No injuriesLimited investigationFinal reportCessna A188B · South Oxford, MSthe pilot's improper use of the brakes during the landing rollout.NTSB ATL84LA220Accident · Minor injuriesLimited investigationFinal reportSnow 600-S2C · Lambert, MSDuring the landing roll the tailwheel reportedly oscillated braking the shock strut lugs allowing the tail of the acft to contact the sod runway. The plt applied hard braking and the acft nosed over. The plt reported nothing was wrong with the tailwheel…NTSB ATL84LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Rosedale, MSThe plt was transporting the acft to a newly constructed, private ag strip to begin aerial application. During the landing roll, one of the main landing gear rolled into a soft spot & sank into the ground, then the acft nosed over.NTSB ATL82DA141Accident · No injuriesFinal reportCessna 170A · Pettibois Islan, MSThe pilot stated that he landed safely on an island after noticing that the engine cowling started to work loose. He successfully repaired the problem but nosed over on the sandy surface during takeoff.