NTSB investigations, FL
6 cases where the first occurrence was “Undetermined”.
Cases per year
| 1984 | 2 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1992 | 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\" = 'FL' 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\" = 400)
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" = 'FL' 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" = 400) 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 MIA95LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Orlando, FLUnknown.NTSB MIA92LA151Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4-200 · FLSubstantial damage to the airplane during Unknown phase of flight for undetermined reasons.NTSB MIA87LA161Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Missing, FLThe acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along…NTSB MIA87LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe pilot stated the aircraft performed sluggishly during takeoff and would not climb to clear trees at the departure end of the runway. The takeoff was aborted and the aircraft overran the runway encountering sand and nosing over. The pilot stated that…NTSB MIA84LA128Accident · 4 fatalLimited investigationFinal reportCessna 172 · Marathon, FLThe acft was missing after departing on a flt from maraton, FL to everglades city, FL. Sar personnel found the bodies of the plt & 3 pax, but the acft was not found. It was presumed to have been destroyed during a crash in the gulf of Mexico.NTSB MIA84LA089Accident · 2 fatalLimited investigationFinal reportCessna P-210N · Key West, FLDuring his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the…