NTSB investigations, LA
11 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 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\" = 'LA' 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\" = 320)
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" = 'LA' 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" = 320) 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 DFW08CA009Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Columbia, LAThe pilot's selection of an unsuitable landing area. Contributing factors were the tall vegetation on the sides of the airstrip and the short and confined landing area.NTSB FTW93IA250Incident · No injuriesIncident investigationFinal reportCessna A185F · Pilottown, LAThe pilot in command becoming physically incapacitated (heart attack).NTSB FTW93LA162Accident · No injuriesLimited investigationFinal reportCessna A185F · Timbalier Isle, LAPilot's inadequate preflight planning and preparation in the selection of his takeoff route. A factor was the sand barNTSB FTW91LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pioneer, LAThe pilot's use of a runway unsuitable due to recent rains.NTSB FTW87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Many, LAAcft received substantial damage when it ran off the end of a 3,300' pvt airstrip into a lake during an attempted go around. The winds were calm. The plt reported that he landed long and fast over trees at the threshold and delayed initiating a go around…NTSB FTW84LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Woodworth, LAThe plt approached an unfamiliar area at less than 500 ft AGL and landed on an abandoned drag race strip about 3 miles from the dest airp. Directional control was lost very shortly after touchdown when the acft collided with dirt piles on the surface of the…NTSB FTW83LA402Accident · No injuriesLimited investigationFinal reportGrumman G-164B · North Lacassine, LAThe plt reported that during the landing, the left wing struck tall grass at the side of the strip & the acft swerved to the left. He tried to correct the situation by applying right braking action, but his braking was ineffective on wet grass. Subsequently,…NTSB FTW83LA220Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bastrop, LAAfter arriving, the plt made a pass over the turf strip to inspect it before landing. He elected to land; however, during the landing roll-out, he saw a ditch running laterally across the strip, but by then, he was unable to avoid it. Subequently, the acft…NTSB FTW83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Breaux Bridge, LAAccording to the pilot he was attempting to takeoff at night from an unlit turf strip. Just before the attempted takeoff, two sets of vehicle headlights were directed down both sides of the rnwy to help the pilot in the takeoff. On both sides of the rnwy,…NTSB FTW82DA354Accident · No injuriesFinal reportGrumman G-164A · Columbia, LADuring takeoff, the left wing of the aircraft contacted the cotton that was growing on the left side of the runway. The pilot reported that he could not lift the wing out of the cotton. When he reduced the power, the aircraft turned left and slid sideways.…NTSB FTW82DA175Accident · No injuriesFinal reportPiper PA-32RT-300 · Pineville, LADuring taxi to the runway for takeoff, the right main gear dropped into an unmarked hole on the right edge of the taxiway resulting in substantial damage to the aircraft.