NTSB investigations, PA
4 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1991 | 1 |
| 1992 | 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\" = 'PA' 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\" = 330)
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" = 'PA' 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" = 330) 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 NYC92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Coatesville, PAThe pilot's decision to continue the approach and eventual touching down off the runway which resulted in a loss of control of the airplane and collapsing the landing gear. A factor in this accident was the pilot's loss of visual perception and fog.NTSB NYC91LA131Accident · No injuriesLimited investigationFinal reportCessna 185C · New Hanover, PAThe loss of directional control by the pilot during a crosswind takeoff and subsequent collision with rough terrain. A factor related to the accident was the pilot's lack of experience in this make and model airplane.NTSB NYC85LA082Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Reading, PAThe acft overturned while awaiting takeoff from Reading,PA. Wind was reported from 310 degs at 16 KTS, gusting to 22 KTS. After engine up the tower advised N66RA tp hold for landing traffic which was a lear jet. Wind at this time was given as 310 KTS at 27…NTSB NYC83LA031Accident · No injuriesLimited investigationFinal reportCessna 172RG · Middletown, PAAfter landing the tower directed the pilot to back taxi on the runway. After clearing the runway the pilot taxied straight ahead with proper control deflections for a 10 degree strong wind behind the left wing. A strong gusty wind was encountered causing the…