NTSB investigations, LA
22 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1993 | 3 |
| 1996 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 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\" = '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\" = 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" = '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" = 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 DFW07LA120Accident · 1 fatalLimited investigationFinal reportCessna U206G · Leeville, LAThe failure of the operator of the powerboat to maintain separation from the departing floatplane.NTSB DFW06CA016Accident · No injuriesData collectionFinal reportCessna 210L · Baker, LAThe pilot's failure to maintain clearance during takeoff roll.NTSB FTW04CA193Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Baton Rouge, LAThe pilot's selection of an unsuitable area for landing. A contributing factor was the high vegetation.NTSB FTW04LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe pilot's delay in aborting the landing. A contributing factor included the entrance of a crawfish boat onto the airstrip.NTSB FTW02LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Bogalusa, LAa deer that ran in front of the airplane during the takeoff phase. A contributing factor was the lack of an airport perimeter fence to prevent deer from entering the runway environment.NTSB FTW96LA175Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Franklin, LAThe pilot's poor judgment in attempting to refuel the helicopter with the engine (and rotors) operating. Factors relating to the accident were: the gusty wind condition, and close proximity of the vehicle that was allowed to be driven under the turning rotors.NTSB FTW93LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pioneer, LAThe failure by both pilots to maintain visual lookout. Factors were the inadequate radio communications by both pilots, and the departing pilot's failure to follow procedures and directives.NTSB FTW93LA179Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe pilot's failure to have the airplane properly attended during start when people were available. A factor was the inadequate tie down rope.NTSB FTW93LA175Accident · No injuriesLimited investigationFinal reportGrumman G-164B · St. Martinville, LAThe pilot's and tractor driver's inadequate visual lookoutNTSB FTW89LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Lake Arthur, LAThe failure of the pilot to see and avoid tree limbs that extended over the edge of the canal. Factors related to the accident were: the tree limbs and dirt bank near the edge of the selected landing area.NTSB FTW88LA133Accident · No injuriesLimited investigationFinal reportCessna 310B · Ruston, LABoth airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310…NTSB FTW85LA291Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Patterson, LAThe acft was substantially damaged when it was rammed by a speed boat after it had landed on a canal and was water taxiing to its tie down area. The boat came out of a crossing canal at high speed and struck the amphib in the area of the left float. The boat…NTSB FTW85LA205Accident · No injuriesLimited investigationFinal reportCessna A185F · Gibson, LAThe amphibian acft was substantially damaged when it collided with a tree while landing on an oil field service canal. The plt stated that he landed long and fast and as a result he was unable to negotiate the second half of an 's' turn in the canal. The left…NTSB FTW85LA004Accident · No injuriesLimited investigationFinal reportCessna A185E · Morgan City, LAPlt arrived at intended lndg site on remote pipeline canal where quarter boat was operating, overflew site and visually checked conditons. After 100-150 yds of landing roll, the right float struck a submerged object. Float filled with water and acft rolled…NTSB FTW84LA275Accident · No injuriesLimited investigationFinal reportCessna A185F · New Iberia, LAWhile decelerating after landing one of the floats contacted a submerged object. Directional control was lost, acft veered to left and collided with a tree on the bank.NTSB FTW84LA203Accident · Serious injuriesLimited investigationFinal reportCessna 185F · Belle Chasse, LAWhen the plt attempted to start the eng, it 'hung up in the middle of the compression stroke.' He stated that after confirming that the magnetos were off, he attempted to 'free the propeller by hand.' The eng started as soon as the propeller was moved. The…NTSB FTW84LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Slidell, LAThe acft collided with submerged objects during takeoff. The takeoff was aborted and the acft ran up on the bayou bank where it collided with trees.NTSB FTW84LA041Accident · No injuriesLimited investigationFinal reportCessna 180K · Patterson, LAAfter landing, the plt was step taxiing the float plane around a slight curve in the canal. As the acft went around the curve, the sun was in the plt's eyes & he did not see a piling until it was directly ahead. He took evasive action, but the left wing…NTSB FTW83LA050Accident · No injuriesLimited investigationFinal reportCessna 185 · Venice, LAPilot making water takeoff pass piers collided with a tug that appeared out of a slip. Aircraft sank.NTSB FTW82DA378Accident · No injuriesFinal reportCessna 180K · New Iberia, LAThe plt encountered detreiorating visibility due to fog & haze & decided to make a precautionary landing on the intracoastal waterway. The plt stated he was blinded by the reflected light when he turned on his landing light & did not see the pilings which…NTSB FTW82DA269Accident · No injuriesFinal reportPiper J3L-65S · New Orleans, LAAfter landing the float plane on a bayou, the pilot started to taxi past an anchored barge on the waterway. The barge was used to support a shrimp net framework. While passing the barge, the right wing of the aircraft struck the framework and was damaged.NTSB FTW82DA066Accident · No injuriesFinal reportCessna A185F · Near Patterson, LAAfter landing the pilot began to step taxi on an unfamiliar canal to a drilling rig location. While negotiating a turn in the canal, the left wing struck a tree limb. The aircraft veered to the left and the right wing dropped and hit the water.