NTSB investigations, MS
7 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1988 | 1 |
|---|---|
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2007 | 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\" = 310)
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" = 310) 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 ERA10CA112Accident · No injuriesData collectionFinal reportBellanca 7ECA · Calhoun City, MSThe pilot's failure to maintain clearance from a fallen tree located off the right side of the runway during takeoff.NTSB DFW06CA005Accident · No injuriesData collectionFinal reportCessna 152 · Tupelo, MSThe pilot's failure to maintain adequate visual lookout during taxi. Contributing factors were the dark night conditions, the unmarked light pole, and the lack of taxiway centerline markings at the parking area.NTSB MIA00LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Steens, MSthe flight instructor failed to maintain control of the airplane after landing, which resulted in an on ground collision with a tree. Factors in this accident were the flight instructor allowed the student to get too fast and high on the approach.NTSB ATL97LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Olive Branch, MSThe farmer's failure to maintain security of his livestock/animals.NTSB MIA95LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Winstonville, MSPoor preflight planning/preparation and clearance not maintained by the pilot in command.NTSB MIA95LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenwood, MSThe student pilot's improper planning/decision concerning the selection/approach/execution of the emergency landing. Factors related to the accident were: the pilot's lack of experience, his becoming lost/disoriented, the light conditions at dusk, and the…NTSB MIA89LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Tupelo, MSThe Cessna plt was taxiing his acft on a marked taxiway when he observed a Piper PA-31-350 (chieftain) entering the taxiway ahead of his acft. The Cessna plt applied the brakes & stated the acft was stopped for 3-4 seconds before the left wing of the Piper…