NTSB investigations, FL
5 cases where the first occurrence was “Forced landing”.
Cases per year
| 1983 | 1 |
|---|---|
| 1987 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 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\" = '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\" = 180)
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" = 180) 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 MIA99LA197Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLthe pilot's improper in-flight decisions allowing the glider to descend to a low altitude, resulting in a forced landing off the airport and subsequent impact with a tree.NTSB MIA95LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Zellwood, FLA loss of aircraft climb capability after the banner pickup for an undetermined reason. A factor related to the accident was: soft terrain in the emergency landing area.NTSB MIA93LA150Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Boynton Beach, FLThe pilot's improper in-flight planning and the lack of adequate thermal lift.NTSB MIA88LA036Accident · No injuriesLimited investigationFinal reportRaven S-66A · Naples, FLAfter liftoff with the deflation panel partially open, the flt continued towards the landing location. With a high rate of descent established, the plt realized that the balloon would not clear the powerlines that were ahead of the landing location. He then…NTSB MIA83LA061Accident · No injuriesLimited investigationFinal reportCessna 182D · Near Telogia, FLThe acft collided with a tree during an off airport precautionary landing. The student pilot was practicing a cross country on a day with questionable weather. The clouds were 1000 feet broken 2500 feet overcast at tallahassee which is 30 miles ene of the…