NTSB investigations, 2000, FL
8 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 8 |
| 1984 | 9 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 6 |
| 1989 | 11 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 10 |
| 1995 | 7 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 2 |
| 2000 | 8 |
| 2001 | 8 |
| 2002 | 5 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 3 |
| 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 year(c.\"eventDate\") = 2000
AND 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\" = 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 year(c."eventDate") = 2000 AND 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" = 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 MIA01LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe student pilot's failure to maintain a visual look out while transitioning from the active runway to a taxiway resulting in an on-ground collision with a taxiway sign.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB ATL00LA083Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Key West, FLFailure of the right brake expander tube which limited the pilots control of the aircraft.NTSB MIA00LA230Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · New Smyrna Bch., FLthe pilot's failure to maintain control of the airplane during the landing roll. Factors in this accident were; a crosswind, and the pilot lack of experience in this kind of aircraft.NTSB MIA00LA206Accident · No injuriesLimited investigationFinal reportBoeing 737-49R · Orlando, FLThe captain's failure to stop the aircraft when given a stop signal by the ground marshaller and his failure to turn the aircraft when given a turn signal by the ground marshaller as he taxied into the gate resulting in the aircraft's left wing colliding with…NTSB MIA00LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLthe dual student's improper visual lookout and the flight instructor's inadequate supervision that resulted in the airplane colliding with a fence post.NTSB MIA00LA124Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Petersburg, FLThe failure of the pilot to maintain clearance between the left wingtip and a hangar door resulting in the on-ground collision.NTSB MIA00LA115Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Miami, FLInadequate visual lookout by the driver of the vehicle.