NTSB investigations: Fokker F.28 MK4000
7 cases on aircraft the registry lists as Fokker F.28 MK4000. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1989 | 1 |
|---|---|
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2000 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4990810'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4990810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 LAX00LA098Accident · Serious injuriesLimited investigationFinal reportFokker FK-28-4000 · Red Bluff, CAthe failure of the passenger to fasten his seat belt without the necessity of being instructed by the flight attendant.NTSB SEA99IA045Incident · No injuriesIncident investigationFinal reportFokker F.28 MK 4000 · Spokane, WAA chafed hydraulic line.NTSB NYC95IA065Incident · No injuriesIncident investigationFinal reportFokker F28-4000 · Huntington, WVThe fatigue fracture of the left main landing gear upper torque link.NTSB CHI95IA045Incident · No injuriesIncident investigationFinal reportFokker F-28-4000 · Evansville, INthe failure of company maintenance personnel to adequately service (fill) the horizontal stabilizer drive actuator with hydraulic fluid.NTSB ATL92IA080Incident · No injuriesIncident investigationFinal reportFokker F.28 MK4000 · Charlotte, NCThe pilot-in-command's decision to reject the takeoff at a speed in excess of V1, resulting in an inadequate distance to stop the aircraft.NTSB DCA92MA025Accident · 27 fatalClass 1 · MajorFinal reportFokker 28-4000 · Flushing, NYThe failure of the airline industry and the federal aviation administration to provide flightcrews with procedures, requirements, and criteria compatible with departure delays in conditions conducive to airframe icing and the decision by the flightcrew to…NTSB MIA89LA228Accident · Serious injuriesLimited investigationFinal reportFokker F-28 MK4000 · Vero Beach, FLIn-flight encounter with unforecast turbulence, which resulted in injury of a flight attendant, who was not wearing a safety belt.