NTSB investigations, PA
18 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 2 |
| 2006 | 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\" = 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" = '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" = 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 NYC07CA002Accident · No injuriesData collectionFinal reportCutler VariEze · Perkasie, PAThe pilot's excessive rotation on takeoff, which resulted in a propeller blade strike, and subsequent forced landing to a field.NTSB NYC04CA143Accident · No injuriesData collectionFinal reportStearman 4E · Loganton, PAThe pilot's failure to maintain aircraft control during the landing roll, which resulted in a nose over. A factor was uneven terrain.NTSB IAD04LA011Accident · No injuriesLimited investigationFinal reportCessna 210E · Pittsburgh, PAThe owner/pilot-mechanic's failure to comply with an airworthiness directive, which resulted in a fatigue fracture to the left main landing gear saddle.NTSB NYC01LA213Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Davidsville, PAThe pilot's failure to abort the takeoff attempt. Factors included the pilot's failure to use both magnetos, and his failure to utilize soft field takeoff procedures.NTSB NYC00LA053Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Shamokin, PAThe pilot's failure to maintain aircraft control.NTSB IAD97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Morgantown, PAThe pilot's improper decision to attempt a landing on and his failure to align with an unlighted runway at night. Factors were the lack of runway lighting and the night light condition.NTSB BFO93LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Centre Hall, PAThe pilot misjudged his airspeed and altitude which resulted in the pilot's failure to attain the proper touchdown point resultng in the airplane exiting the runway and colliding with the berm. A related factor was the location of the berm.NTSB NYC93LA152Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Erwinna, PAThe pilot's failure to maintain aircraft control which resulted in a nose over. A rough uneven runway, and the pilot's diverted attention are contributing factors.NTSB BFO93LA056Accident · No injuriesLimited investigationFinal reportCessna 177RG · Corry, PAFailure of the pilot to maintain runway alignment during the landing roll. Factors related to the accident were: darkness, the pilot's lack of visual cues due to the runway lights being obscured by the plowed snow, and failure of airport personnel to issue a…NTSB BFO92LA039Accident · No injuriesLimited investigationFinal reportLet L-13 · Lock Haven, PAA tow rope that broke at low altitude.NTSB NYC90LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lancaster, PAThe pilot's selection of an unsuitable landing site. Contributing to the accident was the pilots decision to land in a field with insufficient space available.NTSB NYC87LA141Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmyra, PAStudent pilot experienced up and downdrafts while on approach for landing at reigle airport. The pilot was unable to maintain directional control during roll out, ran off the left side of the runway, and across a grass field. The acft then nosed over when the…NTSB NYC85LA144Accident · No injuriesLimited investigationFinal reportCessna 305A · Toughkenamon, PAThe acft ground looped during a landing roll on a sod rwy. The plt stated that during the landing roll, it felt as if the right main gear contacted a knoll of grass resulting in the acft ground looping to the right.NTSB NYC85LA037Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, PAOn takeoff roll, the student pilot allowed the acft to drift left off of the runway. Acft collided with a dirt embankment and flipped inverted.NTSB NYC84LA080Accident · No injuriesLimited investigationFinal reportCessna 172RG · Marietta, PAThe acft struck a snowbank during a night landing. The CFI stated everything was normal until flareout when the acft began to settle. After striking the snowbank the acft nosed over.NTSB NYC84LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Reading, PAThe plt reported that during the flt, then he lost use of his radio & navigation equipment. Reportedly, he was forced to land about 1 mi from the Reading airport due to bad wx. The acft electrical system was checked, but no reason for the electrical failure…NTSB NYC83LA067Accident · No injuriesLimited investigationFinal reportMooney M20E · Butler, PAAfter landing on rwy 25 the plt exited onto a taxiway near midfield to wait for another acft departing rwy 7. The wind was calm & the plt elected to depart rwy 7 as did the other acft. The gear was prematurely retracted during the takeoff roll.NTSB NYC82FGT11Accident · Serious injuriesFinal reportPiper PA-44-180 · Mcsherrystown, PAThe pilot reported that when he arrived at night, there were snow showers at the airport. While turning final, he turnedhis landing lights on. However, he reported that he could see better with the landing lights off, so he turned them off. After touching…